SELECT CASE
WHEN CONNECT_BY_ISLEAF = 1 THEN 0
WHEN LEVEL = 1 THEN 1
ELSE -1
END
AS status,
LEVEL,
menu_desc AS title,
DECODE (0, NULL, 'fa-bars', 'fa-file') AS icon,
child_node AS VALUE,
menu_desc AS tooltip,
APEX_UTIL.prepare_url (
'f?p='
|| :app_id
|| ':'
|| page_no
|| ':'
|| :app_session
|| ':::::')
AS link
FROM (SELECT mennam AS menu_desc,
progcod AS parent_node,
modcod AS child_node,
progmid AS page_no
FROM menumst)
START WITH child_node = 0
CONNECT BY PRIOR parent_node = child_node
ORDER SIBLINGS BY parent_node;
I have faced ORA-01436: CONNECT BY loop in user data error
Main problem data have no proper heretical structure
ReplyDelete