Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between sub query and nested query ?
- 19 Answers
- 67783 Views
- Keane India Ltd, TCS, I also Faced
- E-Mail Answers
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 indexes option in imp command.
What do you understand by a database object? Can you list a few of them?
How to convert character types to numeric types?
Differentiate between pre-select and pre-query?
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
what is a Nested Loop join?
What are named parameters?
Is rowid unique in oracle?
What is the difference between $oracle_base and $oracle_home?
How to work with data objects interactively?
What types of joins are used in writing subqueries?
How to calculate date and time differences in oracle?
What is meant by joins? List out the types of joins.
How to login to the server without an instance?
How to find out what oracle odbc drivers are installed?
