Tutorial by Examples

SELECT E.EMPLOYEE_ID,E.LAST_NAME,E.MANAGER_ID FROM HR.EMPLOYEES E CONNECT BY PRIOR E.EMPLOYEE_ID = E.MANAGER_ID; The CONNECT BY clause to define the relationship between employees and managers.
SELECT E.LAST_NAME|| ' reports to ' || PRIOR E.LAST_NAME "Walk Top Down" FROM HR.EMPLOYEES E START WITH E.MANAGER_ID IS NULL CONNECT BY PRIOR E.EMPLOYEE_ID = E.MANAGER_ID;

Page 1 of 1