查询最高级父级
select * from (select level, t.id
from tablea t
start with t.id = '9567964843314878862be94bff8c8e4c'
connect by id = prior PARENT_ID
order by level desc)
where rownum = 1
查询所有子集
select *
from tablea
start with PARENT_ID = '04dd5b9a17504368946260d644d77ddf'
connect by prior id = PARENT_ID