This content has been marked as final. Show 3 replies
Now this works fine and shows the levels. In the help the start with is actually
select case when connect_by_isleaf = 1 then 0 when level = 1 then 1 else -1 end as status, level, First_name as title, NULL as icon, EMPloyee_id as value, First_name as tooltip, NULL as link from EMPLOYEES start with Manager_id ='171' connect by prior EMPLOYEE_ID = Manager_id order siblings by First_name
Now if we use a lowest level employee using something like
start with Manager_id is null
no rows are returned. This is because there are no child records for this employee (he is not a manager).
start with Manager_id = '171'