In Oracle 10g we find some minor additions to the way the database handles hierarchical queries. This article explains how the use of CONNECT_BY_ROOT, CONNECT_BY_ISLEAF, and CONNECT_BY_ISCYCLE can have some major impact in the way you select data in hierarchical tables.
