通过邮编从地域表中迭代查出地域全名

select listagg(area_name, '-') within GROUP(order by m.area_code)
from t_area m
start with m.area_code = '350001'
connect by prior m.parent_area_code = m.area_code