Hi
With e.g. tree query:
select case when connect_by_isleaf = 1 then 0
when level = 1 then 1
else -1
end as status,
level,
(CASE WHEN "ENAME" = 'KING' THEN null ELSE "ENAME" END) as title, -- null value is evil
null as icon,
"EMPNO" as value,
null as tooltip,
null as link
from "#OWNER#"."EMP"
start with "MGR" is null
connect by prior "EMPNO" = "MGR"
order siblings by "ENAME"
The developer toolbar disappears when there is null value in the Title. This is very very hard to detect problem.
https://apex.oracle.com
workspace: imagetest_ws
user: guru
pass: meditation
app: imgtst
page: 12
Rgrds Paavo