Oracle APEX Custom and Dynamic Navigation Menu
ฝัง
- เผยแพร่เมื่อ 20 ก.ย. 2024
- ***Custom and Dynamic Navigation Menu **
CREATE TABLE ZMENU
(
MENU_CODE VARCHAR2(10 BYTE) NOT NULL,
MENU_DESC VARCHAR2(100 BYTE) NOT NULL,
P_MENU_CODE VARCHAR2(10 BYTE),--(or you can maintain virtually)
STEPS NUMBER(2),
SL NUMBER(3),
IS_WEB VARCHAR2(1 BYTE) DEFAULT 'Y',--(Active /Inactive )
PAGE_NO INTEGER,
ICON_IMG VARCHAR2(100)
);
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 zmenuv
START WITH p_menu_code IS NULL
CONNECT BY PRIOR menu_code = p_menu_code
ORDER SIBLINGS BY sl;
#OracleApex #OracleApexTutorials #NavigationMenu #PKzaman
Lovely 👌👌👌👌
good
but this query not work, kindly guide me