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
What is a partition in oracle?
How to define a record variable to store a table row?
What is oracle server autotrace in oracle?
How is it different from a normal table?
How to connect asp pages to oracle servers?
what is Single Byte Overhead...?
What is save point in oracle database?
What is an oracle user account?
How to export your connection information to a file?
What are the differences between primary key and unique key?
What is the difference between view and materialized view in Oracle?
What is dual table oracle?
How to handle a single quote in oracle sql?
What are the uses of linked server and explain it in detail?
Explain the use of file option in exp command.