查询最高级父级
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










