来自互联网
SELECT * FROM a_ParkingLot AWHERE A.REGIONID IN( SELECT r.ID FROM a_region r START WITH r.id=‘CD79FF2A1E5E49A9B1EAD545A0E05D2C‘ CONNECT BY PRIOR r.ID=r.parentid)
oracle递归查询树的SQL语句
原文：http://www.cnblogs.com/subendong/p/4330329.html
