ITPub博客

SELECT *FROM apps.fnd_compiled_menu_functionsWHERE menu_id = 80343AND function_id IN (SELECT function_idFROM apps.fnd_menu_entries_vlWHERE menu_id = 80343AND grant_flag = 'N')AND grant_flag = 'Y';UPDATE apps.fnd_compiled_menu_functionsSET grant_flag = 'N'WHERE menu_id = 80343AND function_id IN (SELECT function_idFROM apps.fnd_menu_entries_vlWHERE menu_id = 80343AND grant_flag = 'N')AND grant_flag = 'Y'; --7 records to be updatedCOMMIT;[@more@]

DECLARE my_task_name VARCHAR2(30); my_sqltext CLOB;BEGIN my_sqltext := 'SELECT *FROM lc_tun_tempWHERE to_char(lcid) = ''1'''; my_task_name := dbms_sqltune.create_tuning_task(sql_text => my_sqltext, bind_list => NULL, user_name => 'APPS', scope => 'COMPREHENSIVE', time