Understand Oracle 10g's new Hierarchical Query options

September 19, 2005

[From Builder UK]

Oracle 10g adds new pseudo columns to the SQL Hierarchical Queries that use START WITH . . . CONNECT BY . . . clauses. For more than a decade, Oracle SQL has had the ability to cause a query to follow a hierarchical relationship. For instance, you could specify a starting condition and continue to child rows using one or more connection conditions. As an example, suppose I have a table that lists some regions of the world. View Listing A.

The article continues at http://uk.builder.com/0,39026540,39266079,00.htm