查询语句:
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
1111

被折叠的 条评论
为什么被折叠?



