INSERT INTO FBP.FBP_MENU
(LAST_UPDATE_DATE,
LAST_UPDATED_BY,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_LOGIN,
ENABLED_FLAG,
ORG_ID,
MENU_ID,
MENU_CODE,
MENU_NAME,
PARENT_MENU_ID,
ORDER_NUMBER,
PAGE_ID)
SELECT TO_CHAR(SYSDATE, 'yyyymmddhh24miss'),
10000,
TO_CHAR(SYSDATE, 'yyyymmddhh24miss'),
10000,
10000,
'Y',
1,
FBP.FBP_MENU_S.NEXTVAL,
'myBoe',
'我的单据',
(SELECT menu_id FROM FBP.FBP_MENU WHERE MENU_CODE = 'Workbench'),
100,
(SELECT PAGE_ID FROM FBP.FBP_PAGE WHERE PAGE_CODE = 'myBoe')
FROM DUAL
WHERE NOT EXISTS
(SELECT 1 FROM FBP.FBP_MENU WHERE MENU_CODE = 'myBoe');
(LAST_UPDATE_DATE,
LAST_UPDATED_BY,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_LOGIN,
ENABLED_FLAG,
ORG_ID,
MENU_ID,
MENU_CODE,
MENU_NAME,
PARENT_MENU_ID,
ORDER_NUMBER,
PAGE_ID)
SELECT TO_CHAR(SYSDATE, 'yyyymmddhh24miss'),
10000,
TO_CHAR(SYSDATE, 'yyyymmddhh24miss'),
10000,
10000,
'Y',
1,
FBP.FBP_MENU_S.NEXTVAL,
'myBoe',
'我的单据',
(SELECT menu_id FROM FBP.FBP_MENU WHERE MENU_CODE = 'Workbench'),
100,
(SELECT PAGE_ID FROM FBP.FBP_PAGE WHERE PAGE_CODE = 'myBoe')
FROM DUAL
WHERE NOT EXISTS
(SELECT 1 FROM FBP.FBP_MENU WHERE MENU_CODE = 'myBoe');