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

Опубликовано: 05 Ноябрь 2024
на канале: Knowledge Sign

2,483

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:
[email protected]

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