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
How to write numeric literals in oracle?
What is bulk collect in oracle?
Does facebook use oracle?
What is an oracle user role?
State the difference between a primary key and foreign key?
What is oracle datasource?
Explain the use of grant option in imp command.
How to rename a tablespace in oracle?
How to open a cursor variable?
How can Oracle users be audited?
Describe an oracle table?
How to resolve name conflicts between variables and columns?
how the indexes are stored in the Oracle Database?
What is the difference between post-database commit and post-form commit?
How to check database size in Oracle?