Understand Oracle 10g's new Hierarchical Query options

Monday Sep 19th 2005 by DatabaseJournal.com Staff

Some things have changed in the latest generation of Oracle SQL's handling of hierarchical queries. We explain what's new, and how to take advantage of it.

[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

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