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:

Social Media links:
Facebook:

Emails:

Twitter:

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

[paulmichalski]

something is wrong with your code, when you make something a parent it loses the page number that it links to, and only the ones under the parent link to the pages they are assigned.

[allpractical]

why it is not going when we create the child then parent page is not able to navigate only child pages able to redirect to their pages, why? please give us solution