Oracle's START WITH and CONNECT BY clauses in the SELECT statement automatically traverse a hierarchy.

This story continues at
http://www.dbasupport.com/oracle/new...siblings.shtml