oracle递归查询

---- 向上递归,查出自己的所有父级层级（包括自己）
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;