Description: This article details the three new CONNECT BY features in Oracle Database 10g. The examples are based on the same table, and use the same data, as those in my previous article. You may wish to read that article to refresh your memory as to how CONNECT BY queries work. Oracle Database 10g enhances support for querying hierarchical, or tree-structured, data. SQL expert and OTN Member Jonathan Gennick explains.