Class OrderSiblingsByClause

  • All Implemented Interfaces:
    Expression

    public final class OrderSiblingsByClause
    extends AbstractOrderByClause
    In a hierarchical query, if the rows of siblings of the same parent need to be ordered, then the ORDER SIBLINGS BY clause should be used. Either ORDER BY or GROUP BY should not be used, as they will destroy the hierarchical order of the CONNECT BY results.
    BNF: order_sibling_by_clause ::= ORDER SIBLINGS BY orderby_item {, orderby_item}*

    Version:
    2.5
    Author:
    Pascal Filion
    Since:
    2.5