Column Actions

select case when connect_by_isleaf = 1 then 0
when level = 1 then 1
else -1
end as status,
level,
"ENAME" as title,
(case when level = 1 then 'https://static.oracle.com/cdn/apex/24.2.14/r_blue_arrow.gif'
when level = 2 then 'https://static.oracle.com/cdn/apex/24.2.14/r_blue_arrow.gif'
else 'https://static.oracle.com/cdn/apex/24.2.14/r_blue_arrow.gif' end) icon,
"EMPNO" as value,
null as tooltip,
'f?p=34738:22:2916477087349::::P22_SELECTED_NODE:'||empno
as link
from "APEX_PM"."APA$NF_EMP"
start with "MGR" is null
connect by prior "EMPNO" = "MGR"
order siblings by "ENAME"