How to get execution path reports on query statements?
What does sharding mean?
What is a trigger and what are its types?
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
where we have to use ON clause and where we have to use USING clause in JOINS
which language is used to develop the oracle........?
What is pragma restrict_reference in oracle 9i?When we use this?Give me one realtime scenario?
How to test null values?
What is a private synonym?
According to oracle specification VIEW is a object. OBJECT that means anything stored in the oracle database that has the physical existence.why VIEW doesn't take memory in oracle database, but it is treated as a object ?Please explain ?
Explain how are indexes update?
Can a primary key contain more than one columns?
How to change system global area (sga) in oracle?