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
Difference between varchar and varchar2 data types?
Explain oracle’s server parameter file.
Explain an integrity constrains?
Can you assign multiple query result rows to a variable?
How to start a specific oracle instance?
How to create a stored function in oracle?
what are steps for interface? where is exchange rate defined in which table?
How to invoke the data pump import utility?
What are the logical operations?
What are the types of partitions in oracle?
How to write date and time interval literals in oracle?
What is oracle latest version?
How to build data dictionary view an new database?
What is a nested table and how is it different from a normal table?
What is the relation of a user account and a schema in oracle?