APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

comma delimited page list set dynamic menu in oracle apex

User_SMMar 13 2023

I have a create dynamic menu in oracle apex. I want to show comma delimited page list in menu is selected. As like it has been work this image dynamically.

Tbl:

CREATE TABLE  "NAV_MENU"
   ("ID" NUMBER PRIMARY KEY,
    "LEVEL" VARCHAR2(100),
    "NAV_NAME" VARCHAR2(100),
    "PAGE_NO" NUMBER,
    "PAGE_LIST" VARCHAR2(100),
    "PARENT_ID" NUMBER,
    "NAV_ID" NUMBER,
    "ICON" VARCHAR2(50)
   )
/

SQL:
---
select
LEVEL "level",
NAV_NAME "label",
decode( connect_by_isleaf, 0, '','f?p=&APP_ID.:'
|| TO_CHAR(PAGE_NO) 
|| ':&SESSION.:::::' 
) target,
PAGE_LIST as target_list,
'YES' as is_current,
decode(nvl(ICON, 'fa_plus'), 'fa_plus', '', ICON) image
from
NAV_MENU
start with
PARENT_ID is null
connect by
prior NAV_ID = PARENT_ID 
order siblings by ID asc

Added on Mar 13 2023

5 comments

167 views

2 mentions