ORACLE - Hierarchical Queries

ORACLE - Hierarchical Queries

  
Check this out:

Very powerful to retrieve hierarchical Data

http://www.stanford.edu/dept/itss/docs/oracle/10g/server.101/b10759/queries003.htm#i2060615
Hi,

while you're at it check how to do it in SQL Server (2005+) using common table expressions:

http://msdn.microsoft.com/en-us/library/ms186243.aspx

Regards,