Create table tree_menu (
parent_node integer,
child_node integer,
menu_desc varchar2(50),
menu_type varchar2(20),
page_no integer,
icon_img varchar2(100)
);
Alter Table Tree_Menu add constraint pk_treemenu
primary key (menu_type, parent_node);
select level,
menu_desc as label,
decode(page_no, null, null, 'f?p=&APP_ID.:'||"PAGE_NO"||':&APP_SESSION.') as target,
'NO' is_current,
icon_img as image
--decode(page_no, null, 'fa-folder-o', 'fa-file-text') as image
from (select menu_desc,
parent_node,
child_node,
page_no,
icon_img ,
menu_type
from TREE_MENU T where menu_type = 'HOME')
start with child_node is null
connect by prior parent_node = child_node
union all
select level,
menu_desc as label,
decode(page_no, null, null, 'f?p=&APP_ID.:'||"PAGE_NO"||':&APP_SESSION.') as target,
'NO' is_current,
icon_img as image
--decode(page_no, null, 'fa-folder-o', 'fa-file-text') as image
from (select menu_desc,
parent_node,
child_node,
page_no,
icon_img ,
menu_type
from TREE_MENU T where menu_type = 'MAIN')
start with child_node is null
connect by prior parent_node = child_node
--• Business Solutions: --• Enterprise ERP, Database Management & IT Infrastructure --• AI, Cloud
Subscribe to:
Post Comments (Atom)
https://www.linkedin.com/pulse/building-real-time-database-monitoring-dashboard-oracle-khaleeq-tpwxf/
-
# Report Column (only column): 1. Column Formatting > HTML Expression <span style="display:block; width: 200px"> #...
-
when open forms builder then errors FRM-91129: fatal error: no value specified for required environment variable FORMS_BUILDER_CLASSPATH a...
-
Installing Oracle Forms and Reports 12c on Windows 10 64 Bit. Hardware used for this installation is · Intel i3-2370M CPU · ...
-
I wanted to share a little trick I’ve used in APEX for a while now to conditionally format report columns based on their values. I’m sure th...

No comments:
Post a Comment