START WITH Clause

The optional START WITH clause specifies a condition. The row that satisfies this condition becomes the root for beginning the recursive operations of the CONNECT BY clause in hierarchical queries.

The START WITH clause is an extension to the ANSI/ISO standard for SQL. This syntax fragment is part of the Hierarchical Clause.


START WITH Clause

                             (1)   
|--START WITH--| Condition |------------------------------------|

Notes:

See Condition

Usage

The START WITH clause specifies a search condition that the CONNECT BY clause uses for the first iteration of its recursive actions. If you omit the START WITH clause, the CONNECT BY clause treats every row as the root of the hierarchy for the initial set of intermediate results.