想查询员工编码为7566的下属员工信息。会将7566及下属员工,以及更下属的员工信息全部查找出来
SELECT LEVEL, EMPNO, ENAME, MGR
FROM EMP
START WITH EMPNO = 7566
CONNECT BY PRIOR EMPNO = MGR;
以上
想查询员工编码为7566的下属员工信息。会将7566及下属员工,以及更下属的员工信息全部查找出来
SELECT LEVEL, EMPNO, ENAME, MGR
FROM EMP
START WITH EMPNO = 7566
CONNECT BY PRIOR EMPNO = MGR;
以上