CONNECT BY Operators

The CONNECT BY operator can be used to define hierarchical conditions. For more details on the usage of this operator, refer to the CONNECT BY clause in the SELECT statement section.

Syntax

PRIOR operator::=

PRIOR Operator

CONNECT_BY_ROOT operator::=

CONNECT BY Root Operator