Difference between sub query and nested query ?
- 19 Answers
- 64907 Views
- Keane India Ltd, TCS, I also Faced
- E-Mail Answers
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
What is the max number of columns in an oracle table?
How to compare dates in oracle sql?
Difference between varchar and varchar2 data types?
How do I connect to oracle database?
if you ctreate table identity
what is port in oracle? how is it related to database application.
How are extents allocated to a segment?
How to define an oracle cursor variable?
How to define a cusotmer as a supplier in ORACLE R12
Can multiple cursors being opened at the same time?
What are a collation and state the different types of collation sensitivity?
How to fetch the row which has the max value for a column?
What is a user role in oracle?
How do I escape a reserved word in oracle?
Please explain drop constraint oracle?
