看了好几个人博客,写了未经允许不得转载,我不就是想备忘一下嘛,那行,我自己动手操作一遍得了。
数据准备:
向上递归:
即查询当前级别的所有上级
SELECT code,parent_code,name
FROM branch
START WITH code = '2'
CONNECT BY PRIOR parent_code = code
向下递归:
即查询当前的级别的所有子级(只需要将连接的条件置换一下就可以了)
SELECT code,parent_code,name
FROM branch
START WITH code = '2'
CONNECT BY PRIOR code = parent_code