SELECT 1, LEVEL, last_name ||' '|| first_name , '', employee_id
FROM employees
START WITH manager_id IS NULL
CONNECT BY PRIOR employee_id = manager_id
Select 5 columns:
I - Status (0, 1)
II - Hierarchical Level (Oracle LEVEL pseudo column)
III - Label
IV - Icon file name (or null)
V - Value
No comments:
Post a Comment