查询语句:
SELECT lpad('|-',(level-1)*4,' ')||lpad('『',2)||wh_name||rpad('』',2) wh_name
FROM warehouse a
CONNECT BY PRIOR id=p_id
START WITH id=1
SELECT lpad('|-',(level-1)*4,' ')||lpad('『',2)||wh_name||rpad('』',2) wh_name
FROM warehouse a
CONNECT BY PRIOR id=p_id
START WITH id=1