PL/SQL User's Guide and Reference

Full Support for Subqueries

Formerly, PL/SQL allowed subqueries only in the SET, VALUES, and WHERE clauses. Now, PL/SQL also allows subqueries in the FROM clause. Among other things, this adds flexibility to your cursor definitions.

For an example, see "Using Subqueries" .