Purpose

Tests the cardinality of a subquery. It is true only if the cardinality of the subquery is greater than 0; otherwise, it is false.

Syntax

EXISTS (subquery)

Example

SELECT empno, ename, deptno FROM emp e WHERE EXISTS 
  (SELECT deptno FROM dept WHERE e.deptno = dept.deptno)