SELECT lpad('|-',(level-1)*4,' ')||lpad('『',2)||name||rpad('』',2) name from st_tree_test CONNECT BY PRIOR id=parentid START WITH id='0'
查询结果图在附件中。
SELECT lpad('|-',(level-1)*4,' ')||lpad('『',2)||name||rpad('』',2) name from st_tree_test CONNECT BY PRIOR id=parentid START WITH id='0'
查询结果图在附件中。