Difference between sub query and nested query ?

Answer Posted / mohanty

query inside the query is nested query.
it is also called as sub query.
Correlated subquery runs once for each row selected by the
outer query. It contains a reference to a value from the
row selected by the outer query.

Nested subquery runs only once for the entire nesting
(outer) query. It does not contain any reference to the
outer query row.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a partition in oracle?

788


How to define a record variable to store a table row?

797


What is oracle server autotrace in oracle?

858


How is it different from a normal table?

787


How to connect asp pages to oracle servers?

787


what is Single Byte Overhead...?

2295


What is save point in oracle database?

1012


What is an oracle user account?

769


How to export your connection information to a file?

823


What are the differences between primary key and unique key?

738


What is the difference between view and materialized view in Oracle?

870


What is dual table oracle?

713


How to handle a single quote in oracle sql?

795


What are the uses of linked server and explain it in detail?

824


Explain the use of file option in exp command.

874