Oracle Error ORA-30008: CONNECT BY clause must reference a PRIOR

Oracle Error Message

ORA-30008: CONNECT BY clause must reference a PRIOR

Reason for the Error

A CONNECT BY clause did not include a predicate referencing a PRIOR so there was no condition connecting a parent row to its child row.

Solution

Add a reference to a PRIOR in the CONNECT BY clause.