Thursday, July 1, 2010

Connect by Clause

  • The start with connect by clause can be used to select data that has a hierarchical relationship. Recurse condition can make use of the keyword perior.
  • Start with specifies the rows to be identified as a root
  • Siblings by preserves any ordering specified in the hierarchical query clause and then applies the order_by_clause to the siblings of the hierarchy

No comments: