Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between sub query and nested query ?
- 19 Answers
- 68518 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
Is oracle the best database?
What is different types of joins?
When do you get a .pll extension in oracle? Explain its importance
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
How to retrieve data from an explicit cursor?
What are the differences between interval year to month and interval day to second?
How to connect ms access to oracle servers?
What is the usage of analyze command in oracle?
Can we create database in oracle using command line ?
How to resolve the ORA-39133 error in Oracle?
Explain the use of analyse option in exp command.
How many types of cluster table in Oracle?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
Explain overloading. Can functions be overloaded?
What are joins, explain all types of joins?
