How to Create Dynamic Navigation Menu in Oracle APEX
Sometimes user don’t want to go with a default navigation menu then on those cases will go ahead with a dynamic navigation menu so today I will let you know how you can create a dynamic navigation menu.
- Create a table with following this SQL script:
CREATE TABLE "NAVIGATION_MASTER" ("LEVEL" VARCHAR2(100), "NAV_NAME" VARCHAR2(100), "PAGE_NO" VARCHAR2(100), "PARENT_ID" NUMBER, "NAV_ID" NUMBER, "ICON_IMG" VARCHAR2(50) ) /
- Create a Name “Custom Navigation” and Choose the type Dynamic.
- Copy and Paste the following SQL script:
select LEVEL "level", NAV_NAME "label", decode( connect_by_isleaf, 0, '','f?p=&APP_ID.:' || TO_CHAR(PAGE_NO) || ':&SESSION.:::::' ) target, 'YES' as is_current, decode(nvl(ICON_IMG, 'A'), 'A', '', ICON_IMG) image from NAVIGATION_MASTER start with PARENT_ID is null connect by prior NAV_ID = PARENT_ID order siblings by NAV_NAME desc
Go to Shared Components»User Interfaces then Change Navigation Menu List from Desktop Navigation menu to “Custom Navigation” which I have created.
Create a form on apex page with a default process based on the table “Navigation_Master”.
Now Enjoy! you can create your own navigation menu directly from pages.