---- 向上递归,查出自己的所有父级层级(包括自己)
select * from department sdi
START WITH sdi.folderid='008023523'
CONNECT BY PRIOR sdi.pfolderid = sdi.folderid
---- 向下递归查出自己的所有子级层级(包括自己)
select * from department sdi
START WITH sdi.folderid=‘001028001’
CONNECT BY PRIOR sdi.folderid = sdi.pfolderid
–按层级排序
select * from department sdi
START WITH sdi.folderid=‘008023523’
CONNECT BY PRIOR sdi.pfolderid = sdi.folderid
order by level desc;