--正向递归
select * from ORGANIZE t start with OID = '' CONNECT BY PRIOR OID=POID
--反向递归
select * from ORGANIZE t start with OID = '' CONNECT BY nocycle prior POID=OID
结果会按照递归顺序排列,如反向递归:
--正向递归
select * from ORGANIZE t start with OID = '' CONNECT BY PRIOR OID=POID
--反向递归
select * from ORGANIZE t start with OID = '' CONNECT BY nocycle prior POID=OID
结果会按照递归顺序排列,如反向递归: