Oracle – Start With…Connect Byhttp://halisway.blogspot.com/2006/04/sql-connect-by.htmlhttp://www.java2s.com/Code/Oracle/Hierarchical-Query/HierarchicalQueriesSTARTWITHandCONNECTBYPRIORclauses.htm