来自互联网
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)