Oracle connect by

There is a good article about oracle connect by.

http://www.dba-oracle.com/t_advanced_sql_connect_by_loop.htm

It introduced CONNECT BY NOCYCLE and some pseudo column like  CONNECT_BY_ISCYCLE and CONNECT_BY_ISLEAF