Search notes:

Oracle: WHERE clause subqueries

The following where clause subqueries are possible in Oracle:
Single-row The subquery returns zero or one record.
Oracle Subquery: EXISTS, NOT EXISTSexists, not exists]
in, not in
any, all

See also

SQL execution plans for subqueries in where clauses.

Index