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

This story continues at http://www.databasejournal.com/news/article.php/3650306