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

　　

 

posted @ 2020-03-04 09:49  石shi  阅读(247)  评论(0)  编辑  收藏  举报