What is subquerry? Tpes of subqurries? Use of subqurry?

Showing Answers 1 - 2 of 2 Answers

DIPTENDU HUI

  • Jan 28th, 2006
 

1.Subquery is nothing but a query inside a query which appears only after the WHERE clause of a select statement.

2.Two types of subquery is there:

a) Co-Related subquery

b) Non-Co-related subquery.

3. Use of subquery is to run or execute your subquery accoring to the best Execution plan available with Oracle.

  Was this answer useful?  Yes

Sheraz Baig

  • Nov 22nd, 2013
 

Subquery is basically Query Withing Query.. and the Result of Subquery is used by Outer query and Subquery could be at any level its not level restricted...

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions