Start With/Connect By Clause

The following construct can be used in USoft Developer in most places:

SELECT...

FROM ...

CONNECT BY ...

START WITH ...

On Oracle, the START WITH clause can precede the CONNECT BY clause.

Exceptions:

CONNECT BY and START WITH cannot be used:

•In constraints.

•In the SQL statement of a logical view.

•When selecting from component tables.