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