Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between sub query and nested query ?
- 19 Answers
- 68395 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
How do I manually create a database in oracle?
What do you mean by redo log file mirroring?
definition of cluster and non-clustered index?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
How many file formats are supported to export data?
What is the difference between pre-select and pre-query?
How to join two tables in a single query using oracle?
Where do we use decode and case statements?
Explain oracle instance.
How to create a new table in oracle?
Why is oracle so popular?
What privilege is needed for a user to create indexes in oracle?
What are the most common interview questions on ETL Testing for experience?
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
What are the differences between date and timestamp in oracle?
