日期:2014-05-17 浏览次数:20915 次
SELECT LEVEL, LPAD('---', 2 * LEVEL - 1) || E.ENAME NAME FROM SCOTT.EMP E START WITH E.MGR IS NULL CONNECT BY PRIOR E.EMPNO = E.MGR;