Understand Oracle 10g's new Hierarchical Query options

Monday Sep 19th 2005 by DatabaseJournal.com Staff
Share:

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

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