Using the CONNECT BY and START WITH Clauses
The syntax for the CONNECT BY and START WITH clauses of a SELECT statement is as follows:
SELECT [LEVEL], column, expression, ...
FROM table
[WHERE where_clause]
[[START WITH start_condition] [CONNECT BY PRIOR prior_condition]];
View Complete Post