Search notes:
Oracle Subquery: EXISTS, NOT EXISTS
See also
in
and
not in
predicates
Semi joins
The
SQL plan operator
HASH JOIN SEMI
Subqueries
in the
where
clause
Index