2020-12-24 oracle connect by prior 查询父子级

   声明:本站部分内容来自互联网,如若本站内容侵犯了原著者的合法权益,可联系我们进行处理。

24

查询最高级父级

select * from (select level, t.idfrom tablea tstart with  t.id = '9567964843314878862be94bff8c8e4c'connect by id = prior PARENT_IDorder by level desc)where rownum = 1

查询所有子集

 

select *from tableastart with PARENT_ID = '04dd5b9a17504368946260d644d77ddf'connect by prior id = PARENT_ID