[Oracle] 利用START WITH显示树形结构

     --显示上下级关系
     SELECT EMPNO, ENAME, LEVEL, MGR
       FROM SCOTT.EMP   
 START WITH MGR IS NULL
 CONNECT BY PRIOR EMPNO = MGR;

     --利用LPAD每一级添加4个空格
     SELECT LPAD(' ', 4 * LEVEL - 4) || ENAME AS ENAME, LEVEL, EMPNO, MGR
       FROM SCOTT.EMP   
 START WITH MGR IS NULL
 CONNECT BY PRIOR EMPNO = MGR;