Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between sub query and nested query ?
- 19 Answers
- 67611 Views
- Keane India Ltd, TCS, I also Faced
- E-Mail Answers
Answer Posted / vrushali
Co-related sub query is one in which inner query is
evaluated only once and from that result outer query is
evaluated.
Nested query is one in which Inner query is evaluated for
multiple times for gatting one row of that outer query.
ex. Query used with IN() clause is Co-related query.
Query used with = operator is Nested query
| Is This Answer Correct ? | 8 Yes | 68 No |
Post New Answer View All Answers
Can we commit inside a function in oracle?
Give the different types of rollback segments.
What are advantages of dateset in datastage?
How to use fetch statement in a loop?
Explain the difference between sql and oracle?
why dont we assign not null constraint as table level constraint.
How to use windows user to connect to the server?
How to assign a table row to a record variable?
Can we write insert statement in function in oracle?
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
What is meant by joins? List out the types of joins.
How to omit columns with default values in insert statement in oracle?
What are set operators?
How to revoke create session privilege from a user in oracle?
What is system tablespace?
