CONNECT BY LEVEL
SELECT employee_id, name, manager_id , LEVEL
FROM employees
CONNECT BY PRIOR employee_id = manager_id;
CONNECT BY PRIOR
SELECT employee_id, name, manager_id, LEVEL
FROM employees
CONNECT BY PRIOR employee_id = manager_id;
START WITH
SELECT employee_id, name, manager_id, LEVEL
FROM employees
START WITH employee_id = 'Emp_No'
CONNECT BY PRIOR employee_id = manager_id;
ORDER SIBLINGS BY (column_name)
SELECT employee_id, name, manager_id, LEVEL
FROM employees
START WITH employee_id = 'Emp_No'
CONNECT BY PRIOR employee_id = manager_id;
ORDER SIBLINGS BY name;
