Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between sub query and nested query ?
- 19 Answers
- 68515 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
What happens if you use a wrong connect identifier?
What is a nested table?
What do you mean by merge in oracle and how can we merge two tables?
Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.
What is oracle sid?
Explain oracle data types with examples?
Write a syntax for update query in oracle?
How to declare a local variable?
What is a schema in oracle?
What are the limitations oracle database 10g xe?
what is Single Byte Overhead...?
How to get a create statement for an existing table?
How to establish administrator authentication to the server?
What is different types of joins?
What is snapshot is too old? Give and example for better understand.
