Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between sub query and nested query ?
- 19 Answers
- 68997 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 define in oracle?
How to define an anonymous procedure with variables?
How different is ms access and oracle?
Does oracle charge for java?
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
How to use existing values in update statements using oracle?
What is set operator oracle?
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
What is a snapshot log?
what is difference between sql plus and sql*plus? (not sql and sql plus).
How do I manually create a database in oracle?
What is the maximum limit on the number of columns in a table?
How to loop through a cursor variable?
How remove data files before opening a database?
What is oracle latest version?
