Sunday, December 04, 2011

Oracle Forms Hierarchical Tree


 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