[Oracle] Oracle自连接实例

    SELECT *
      FROM SCOTT.EMP T1, SCOTT.EMP T2 
     WHERE T1.MGR = T2.EMPNO(+)
  ORDER BY T2.EMPNO;