Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between sub query and nested query ?
- 19 Answers
- 67627 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 data dictionary and how can it be created?
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
Point the difference between translate and replace?
what is dynamic SGA and static SGA
How to use existing values in update statements using oracle?
 How to use an oracle sequence generator in a mapping?
What is data file?
Explain coalesce function?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
does the query needs a hint to access a materialized view?
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
Explain the difference between sap and oracle?
Can multiple cursors being opened at the same time?
How to select all columns of all rows from a table in oracle?
Explain the blob datatype?
