Hierarchical

Use:

  1. START WITH
  2. CONNECT BY PRIOR
  3. ORDER SIBLINGS BY

Managers and their staff: 

SELECT last_name, employee_id, manager_id, LEVEL
  FROM employees
 START WITH employee_id = 100
CONNECT BY PRIOR employee_id = manager_id
 ORDER SIBLINGS BY last_name;

LAST_NAME                 EMPLOYEE_ID MANAGER_ID      LEVEL
------------------------- ----------- ---------- ----------
King                              100                     1
Cambrault                         148        100          2
Bates                             172        148          3
Bloom                             169        148          3
Fox                               170        148          3
De Haan                           102        100          2



Top Next