What are the values that can be specified for OPTIMIZER
MODE Parameter ?
What is Trace File ?
write a query that displays every Friday in a year with date?
how can find the second max sal for every group(i.e i want group the data based on key and find the second max sal for every group
What are Schema Objects ?
What is tablespace in oracle? how can we create? how is it manage? . . . Thnx 2 All in Advnc....:)
Query to get max and second max in oracle in one query ?
34 Answers CTS, Keane India Ltd, TCS, Wipro,
I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database
What are the commands youd issue to show the explain plan for select
3. Display all the client numbers in the ORDER table. Remove duplicates.
How to define a procedure inside another procedure?
Explain self joins in oracle?
What is a Shared SQL pool ?