Class StartWithClause

  • All Implemented Interfaces:
    Expression

    public final class StartWithClause
    extends AbstractConditionalClause
    A START WITH clause is optional and specifies the root row(s) of the hierarchy. If this clause is omitted, then Oracle uses all rows in the table as root rows. The START WITH condition can contain a subquery, but it cannot contain a scalar subquery expression.
    BNF: start_with_clause ::= START WITH conditional_expression

    Version:
    2.5
    See Also:
    HierarchicalQueryClause
    Author:
    Pascal Filion
    Since:
    2.5