-- 树状查询
select t.ID, t.AREACODE, t.AREANAME, t.PARENTAREAIDS, level,(PRIOR AREACODE) as parentcode ,(PRIOR AREANAME) as parentAREANAME
from SYS_REGIONAL t
start with t.PARENTAREAIDS = '0'
connect by prior t.ID = t.PARENTAREAIDS
order by level, t.AREACODE