Oracle start with .... connect by

It is a very useful script. I never use it before it like a recursive loop to get all the result in single SQL query.

http://www.adp-gmbh.ch/ora/sql/connect_by.html