Difference between sub query and nested query ?
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 redo log?
What are the different types of record groups in oracle? Explain each of them
Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?
How to define an anonymous block?
What is a subquery in oracle?
List the types of joins used in writing subqueries?
How to view the data files in the current database?
How to open a cursor variable?
How does Oracle guarantee data integrity of data changes?
How to find out what oracle odbc drivers are installed?
How to establish administrator authentication to the server?
What is the difference between substr and instr?
What is memory advisor in Oracle?
Explain the types of exception?
Where do we use decode and case statements?