This oracle tutorial is about using sub-queries in SQL SELECT statements in Oracle Database 11g. A subquery is a query that put inside a main query and pass the results of the query to the main query.A subquery in the FROM clause of a SELECT statement is also called an inline view. A subquery in the WHERE clause of a SELECT statement is also called a nested subquery.
Download: Using Sub-queries