Oracle递归查询（适合树形结构）

select *from V_PLACE_DEVICE 
START WITH ID=${SELECTID}
CONNECT BY PRIOR PARENTID = ID