The START WITH clause is used to determine the rows selected by table_expression. These rows are used as the root nodes. All rows selected by table_expression where start_expression evaluates to true are regarded as a root node of a tree. The number of potential trees in the result set is equal to the number of root nodes. If the START WITH clause is omitted, every row returned by table_expression is a root of its own tree.
How helpful was this page?
What might be the problems?