Oracle递归sql

--正向递归
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

结果会按照递归顺序排列，如反向递归：