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
Explain the use of grant option in imp command.
What is a directory object?
Explain user account with reference to oracle.
How can I introduce multiple conditions in like operator?
How to get a create statement for an existing table?
What is redo log?
How to work with data objects interactively?
How to convert characters to dates in oracle?
What are a collation and state the different types of collation sensitivity?
How to use fetch statement in a loop?
Difference between open_form and call_form in oracle.
How to create a new table in your schema?
What is a trigger and what are its types in oracle?
Can a formula column referred to columns in higher group ?
How do I limit the number of rows returned by an oracle query after ordering?