Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between sub query and nested query ?
- 19 Answers
- 67782 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 is backup in Oracle?
What are the different types of database objects?
How do you bind variables in oracle?
What is recycle bin in Oracle?
How to create a new user account in oracle?
Calculate difference between 2 date / times in oracle sql?
Will you be able to store pictures in the database?
Explain joins in oracle?
What is ordinary table in oracle?
Difference between inner join vs where ?
How to connect to a local oracle 10g xe server?
How to delete all rows a table in oracle?
How to drop a tablespace?
What is a trace file and how is it created in oracle?
What is a user account in oracle?
