How to order SIBLINGS in Oracle hierarchy queries

Wednesday Dec 20th 2006 by DatabaseJournal.com Staff
Share:

Oracle's START WITH and CONNECT BY clauses in the SELECT statement automatically traverse a hierarchy.

[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

Share:
Home
Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved