oracle遍历树

1：首先数据库中表必须是树形结构的

2：super_department_id 为 department_id 的父节点编号

3：以下语句的执行结果是：department_id = 88 所有字节点及子子节点的记录

 

select * from pub_department a start with a.department_id = 88 connect by prior a.department_id = a.super_department_id

 

 

 

遍历此节点到祖先节点：

   select * from tree t  connect by prior t.parent= t.child start with t.child='001190360'

遍历此节点到孙子节点：

   select * from tree t  connect by priort.child =t.parent start with t.child='001190360'