Difference between sub query and nested query ?
Answer Posted / roshan
ONE THING I WOULD LIKE TO TELL.. SUBQUERY RUNS MUCH FASTER
THAN CO-RELATED QUERY..
BECAUSE EACH TIME IT HAS TO COMPARE THE OUTER QUERY IS
EVALUATED EACH TIME............
Is This Answer Correct ? | 7 Yes | 4 No |
Post New Answer View All Answers
How to do a full database export?
What is the difference between a primary key & a unique key?
What are the numeric comparison operations?
What is Redo Log Buffer in Oracle?
is there a tool to trace queries, like profiler for sql server?
How to check the server version in oracle?
In which language oracle has been developed?
Difference between inner join vs where ?
How to retrieve values from data fields in record variables?
Point the difference between translate and replace?
How to define a sub function?
How to turn on or off recycle bin for the session?
can u plz provide me oca sql dumps please i need them
What are ddl statements in oracle?
What are the different types of trigger and explain its various uses and functions?