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.
PRIOR operator::=
CONNECT_BY_ROOT operator::=