SELECT * FROM EMP START WITH MGR=(SELECT MGR FROM EMP WHERE ENAME='SMITH') CONNECT BY PRIOR EMPNO=MGR;