Difference between sub query and nested query ?
- 19 Answers
- 64771 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
What is a oracle database?
Explain integrity constraint?
What is integrity and what is constraint??Explain with example
Explain what does a control file contain?
What is partitioned table in Oracle?
In what script is snap$ created? In what script is the scott/tiger schema created?
What is Redo Log Buffer in Oracle?
What is a connect identifier?
How to synchronize 2 schema's objects?
Give the advantages and disadvantages of clusters.
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
Please explain joins in oracle?
Can a formula column referred to columns in higher group ?
How to create a stored procedure in oracle?
Explain how you would restore a database using RMAN to Point in Time?
