What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?
2 4524What is the effect of setting the value 'FIRST_ROWS' for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
1 4433What is the effect of setting the 'RULE' for OPTIMIER_GOAL parameter of the ALTER SESSION Command ?
1 3948Difference between primary key and unique key ?
Accenture, B2B Software Technologies, Cognizant, HP Finsoft, IndiaNIC, Karomi Technology, Keane India Ltd, L&T, Onward eServices, R Systems, Shakti, Techtic Solutions,
77 210784Post New Oracle General Questions
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??
Why do we use bulk collect in oracle?
What is a select query statement in oracle?
How to use null as conditions in oracle?
What is control file used for?
Are truncate and delete commands same? If so why?
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.
Point the difference between translate and replace?
What privilege is needed for a user to create indexes in oracle?
What is a trigger and what are its types?
what are steps for interface? where is exchange rate defined in which table?
What is a tns service name?
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?
How translate command is different from replace?
Which is better Oracle or MS SQL? Why?