Start With/Connect By Clause

Previous Next

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.