oracle 递归查询

oracle递归查询父
select * from KM_PROCESS p
start with p.WB_ID='20130423055636'
connect by prior p.PARENT_WBS_CODE=p.WB_ID

oracle递归查询子
select * from KM_PROCESS p
start with p.WB_ID='20130423055636'
connect by prior p.WB_ID=p.PARENT_WBS_CODE