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.