Oracle 递归查询

select * from table connect by prior cur_id=parent_id start with cur_id=???

--子查父（通过子节点向根节点追朔.）
查询〔特下边〕的父节点
select FsysId,FSortName,FSortTopId,FSortAddress,FSortIsList from TVideoSort
start with FsysId='3703E5CD81E48D6BE040007F01001254'--这个是特下边的fsysid
connect by prior FSortTopId=FsysId
order by FsortAddress

――父查子（通过根节点遍历子节点.）
查询〔特下边〕的子节点：结果
select FsysId,FSortName,FSortTopId,FSortAddress,FSortIsList
from TVideoSort start with FsysId='3703E5CD81E48D6BE040007F01001254' --这个是特下边的fsysid
connect by prior FsysId=FSortTopId order by FsortAddress

查询〔特长练习〕的子节点：结果
select FsysId,FSortName,FSortTopId,FSortAddress,FSortIsList
from TVideoSort start with FsysId='36AE4D68EC7D364CE040007F01000CA5'
connect by prior FsysId=FSortTopId order by FsortAddress