Dynamic List Query :
select level ,menu_name label,'f?p=&APP_ID.:'||page_no||':'||:APP_SESSION||':::::' target,'NO' is_current, null image
from menu_info
where menu_no in( (select MENU_NO from MENUPREVS_DETAIL where role_no =(SELECT USER_LEVEL FROM USER_INFORMATION WHERE LOGIN_NAME=:APP_USER)) )
AND NVL(PAGE_ALIAS,1)='1'
start with parent_menu_no is null
connect by prior menu_no=parent_menu_no
Brother Table er Code gulo dele valo hoto....
ReplyDeletehttps://www.foxinfotech.in/2019/07/oracle-apex-tree-example.html
Deletehttps://www.foxinfotech.in/2019/07/oracle-apex-dynamic-popup-navigation-menu-example.html
https://www.foxinfotech.in/2019/07/oracle-apex-creating-custom-user-access-control.html
Welcome,Brother.
Deleteno table structure, no sample data... one can refer to this link
ReplyDeletefirst: https://www.foxinfotech.in/2019/07/oracle-apex-tree-example.html
second: https://www.foxinfotech.in/2019/07/oracle-apex-dynamic-popup-navigation-menu-example.html
third: https://www.foxinfotech.in/2019/07/oracle-apex-creating-custom-user-access-control.html