關於 oracle sql 的遞迴查詢

各個常常會愈到階層關係比如










這時候 可以使用 查詢

 

 -- 向上查詢階層
   select * from org o 
   start with o.id = 123
   connect by o.id = prior o.parent_id;

--  向下查詢階層
   select * from org o 
   start with o.id = 123
   connect by prior o.id = o.parent_id;