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='123456'--Õâ¸öÊÇÌØϱߵÄfsysid
connect by prior FSortTopId=FsysId
order by FsortAddress
--¸¸²é×Ó£¨Í¨¹ý¸ù½Úµã±éÀú×Ó½Úµã.£©
²éѯ¡²ÌØϱߡ³µÄ×ӽڵ㣺½á¹û
select FsysId,FSortName,FSortTopId,FSortAddress,FSortIsList
from TVideoSort start with FsysId='123456' --Õâ¸öÊÇÌØϱߵÄ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