Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between sub query and nested query ?
- 19 Answers
- 68998 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
Explain parameter file in oracle.
How can I see all tables in oracle?
What is an external table?
What is a data dictionary and how can it be created?
How to write a query with a left outer join in oracle?
Difference between varchar and varchar2 data types?
Explain the use of log option in exp command.
How to calculate date and time differences in oracle?
How do I know if oracle client is installed on windows?
How to open a cursor variable?
How to change user password in oracle?
What is java oracle used for?
What happens if the update subquery returns multiple rows?
what are steps for interface? where is exchange rate defined in which table?
How will you write a query to get a 5th rank student from a table student_report?
