级联sql

select ID, PID, NAME,KEY
from HS_DICT
start with KEY = 'HS_EXP_WORK_LOCATION'
connect by prior ID = PID
order by DISPLAYORDER

posted @ 2013-12-20 11:30  真大闸蟹  阅读(182)  评论(0)  编辑  收藏  举报