Subqueries in Oracle

Subqueries in Oracle

Subqueries are select statements which are part of main select statement.

Subqueries can be used in below clauses of a SELECT statement.

  • WHERE
  • HAVING
  • FROM
  • ORDER BY

Subqueries are of two types:

  • Single row subqueries
  • Multiple row