What is difference between co-related sub query and nested sub query?
- 1 Answers
- 660 Views
- I also Faced
- E-Mail Answers
Answer / Chandrakant Giri
A correlated subquery depends on outer query's columns, so it accesses them for each row of the outer query. A nested subquery does not depend on the outer query's columns and is processed before the outer query. In other words, a correlated subquery can be thought of as embedded inside the main query, while a nested subquery acts as a separate unit.
| Is This Answer Correct ? | 0 Yes | 0 No |
Tell me about standby database? What should we watch out for?
What is a database instance?
How many databases should a dba manage?
What do you mean by oracle dba?
What skills should a dba have?
Tell me about standby database? What are some of the configurations of it?
If you see a pin hit ratio of less than 0.8 in the estat library cache report is this a problem? If so, how do you fix it?
Guideline for sizing db_block_size and db_multi_block_read for an application that does many full table scans?
What is dba software?
What does the no logging option do? Why would we be careful of using it?
What is the advantage of using rman?
How can you find dead processes?
Oracle General 
