Oracle Traversal Tree

1: First the table in the database must be 2 of the tree structure:super_department_id For department_id The parent node number 3: The following statements are executed as a result:department_id = 88 records for all byte points and child nodesSELECT * FROM Pub_department a start with A.department_id = prior connect by a.department_id = A. super_department_id

Traverse this node to the ancestor node:

SELECT * from the tree T connect by prior t.parent= T.child start with t.child= ' 001190360 '

Traverse this node to the grandson node:

SELECT * from tree t connect by Priort.child =t.parent start with t.child= ' 001190360 '

Oracle Traversal Tree