--正向递归查询(根据id查询自己和自己一下的数据)
select * from table
start with id=9842
connect by prior id= parentId
order by id
--反向递归查询(根据叶子ID查出自己和自己之上的根数据)
select * from table
start with id=9842
connect by nocycle prior parentId=id
order by id