ORA-30008: CONNECT BY clause must reference a PRIOR
What triggered 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.What should we do to fix it:
Add a reference to a PRIOR in the CONNECT BY clause.