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
原文：http://www.cnblogs.com/s0611163/p/7238801.html
