menu issue
SELECT *
FROM apps.fnd_compiled_menu_functions
WHERE menu_id = 80343
AND function_id IN (SELECT function_id
FROM apps.fnd_menu_entries_vl
WHERE menu_id = 80343
AND grant_flag = 'N')
AND grant_flag = 'Y';
UPDATE apps.fnd_compiled_menu_functions
SET grant_flag = 'N'
WHERE menu_id = 80343
AND function_id IN (SELECT function_id
FROM apps.fnd_menu_entries_vl
WHERE menu_id = 80343
AND grant_flag = 'N')
AND grant_flag = 'Y'; --7 records to be updated
COMMIT;[@more@]
FROM apps.fnd_compiled_menu_functions
WHERE menu_id = 80343
AND function_id IN (SELECT function_id
FROM apps.fnd_menu_entries_vl
WHERE menu_id = 80343
AND grant_flag = 'N')
AND grant_flag = 'Y';
UPDATE apps.fnd_compiled_menu_functions
SET grant_flag = 'N'
WHERE menu_id = 80343
AND function_id IN (SELECT function_id
FROM apps.fnd_menu_entries_vl
WHERE menu_id = 80343
AND grant_flag = 'N')
AND grant_flag = 'Y'; --7 records to be updated
COMMIT;[@more@]
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/59792/viewspace-1060753/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
dbms_sqltune
下一篇：
没有了~
请登录后发表评论
登录
全部评论
