How to order SIBLINGS in Oracle hierarchy queries
December 20, 2006[From Builder.com]
Oracle's START WITH and CONNECT BY clauses in the SELECT statement automatically traverse a hierarchy. Without this feature, a complex self-join would be required to identify which rows are logically related to others. The START WITH clause identifies the row or rows to be considered the starting points, or "roots," of the hierarchy. The CONNECT BY PRIOR clause then indicates how to identify which rows are related to each other.
The article continues at http://builder.com.com/5100-6388_14-6142230.html?tag=sc