Oracle递归查询
时间：2022-03-15 03:18
SQL：
select * from PT_ORG_INFO START WITH id=‘102‘ CONNECT BY PRIOR id=par_idView Code
连表递归查询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=1View Code
