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 does Oracle guarantee data integrity of data changes?
how do u setup a replication site?
How to enter a new row into a table interactively?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
What is memory advisor in Oracle?
Explain the difference between sap and oracle?
What is the disadvantage of User defind function?
What do database buffers contain?
What is the quickest way to export a table to a flat file?
while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511
What is a sub query and what are the different types of subqueries?
What is the sid in oracle?
What are the various oracle database objects?
How to delete an existing row from a table in oracle?
How to sort the query output in oracle?