Oracle递归查询

SQL：

select * from PT_ORG_INFO START WITH id='102' CONNECT BY PRIOR id=par_id

连表递归查询SQL：

select info.* 
from PT_CAMERA_INFO info
join (select * from PT_ORG_INFO START WITH id='102' CONNECT BY PRIOR id=par_id) org on org.id=info.org_id
where 1=1