select ID, PID, NAME,KEY
from HS_DICT
start with KEY = 'HS_EXP_WORK_LOCATION'
connect by prior ID = PID
order by DISPLAYORDER
转载于:https://www.cnblogs.com/dazhaxie/p/3483532.html
select ID, PID, NAME,KEY
from HS_DICT
start with KEY = 'HS_EXP_WORK_LOCATION'
connect by prior ID = PID
order by DISPLAYORDER
转载于:https://www.cnblogs.com/dazhaxie/p/3483532.html