Start With/Connect By Clause
The following construct can be used in USoft Developer in most places:
CONNECT BY ...
START WITH ...
On Oracle, the START WITH clause can precede the CONNECT BY clause.
CONNECT BY and START WITH cannot be used:
•In the SQL statement of a logical view.
•When selecting from component tables.