What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?
How can I create database in oracle?
How to restrict the duplicate records in table valuesets
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
What is indexing, and how does it improve performance?
A VIEWS takes memory in the database. If yes, how can u proove it? is there any way to display the size of views?
What privilege is needed for a user to insert rows to tables in another schema?
How you open and close a cursor variable.Why it is required?
What do database buffers contain?
I have table-A(1,2,3)& table-B(3,4,5).what is the different b/w below questions? A union all B? B union all A?
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??
How to select some rows from a table in oracle?
What is the difference between "as" and "is" in an oracle stored procedure?