Create "Dynamic Navigation Menu" Using DB Table in Oracle Apex

Create "Dynamic Navigation Menu" Using DB Table in Oracle Apex
#Code:
CREATE TABLE "TB_MENU"
( "MENU_CODE" NUMBER,
"MENU_DESC" VARCHAR2(100),
"P_MENU_CODE" NUMBER,
"IS_WEB" VARCHAR2(1) DEFAULT 'Y',
"PAGE_NO" NUMBER,
"ICON_IMG" VARCHAR2(100),
“SL” NUMBER
);
USING THIS BELOW CODE IN NAVIGATION MENU AREA
SELECT LEVEL ,
MENU_DESC LABEL,
DECODE (CONNECT_BY_ISLEAF,0, '','f?p=&APP_ID.:' || TO_CHAR (PAGE_NO)||':&SESSION.:::::') TARGET,
'YES' IS_CURRENT,
NVL(ICON_IMG, 'fa-apex_square') image,
p_menu_code
from TB_menu
START WITH P_MENU_CODE IS NULL
CONNECT BY PRIOR MENU_CODE = P_MENU_CODE
For More Videos,
Please Subscribe my Channel:
/ @knowledgesign22
Social Media links:
Facebook:
/ sharjeelrehmi
Emails:
[e-mail]
Twitter:
/ sharjeelrehmi
Oracle APEX
Dynamic Navigation Bar in Oracle APEX
Oracle APEX Top Navigation Menu
Oracle
How to Create Menu in Oracle APEX
How to Create a Menu in APEX
Dynamic Tree in APEX
Oracle APEX Dynamic
Introduction to Navigation Menus in Oracle APEX
Dynamic Menu Creation in Oracle APEX
Oracle APEX Side Navigation Menu
Oracle APEX Navigation Menu Color
Oracle APEX Navigation Menu Expand
Create Dynamic List in Oracle APEX
How to Send Email Using Oracle APEX