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