Oracle递归查询语句

select parent_id,F_id,F_name,level from risk_ver
where level=2
start with parent_id='0'
connect by prior f_id=parent_id
order  siblings by f_id

  

原文地址:https://www.cnblogs.com/sunliyuan/p/12407751.html