Oracle递归查询

连表递归查询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

Oracle递归查询

标签：select   camera   isp   start   rom   connect   pen   sql   onclick