摘要： 1.List E-Business Suite Profile Option Values For All LevelsSELECT p.profile_option_name SHORT_NAME, n.user_profile_option_name NAME, decode(v.level_id, 10001, 'Site', 10002, 'Application', 10003, 'Responsibility', 10004, 'User', 10005, 'Server', 10006, 'O 阅读全文

摘要： SyntaxFND_PROFILE.SAVE(<Profile_Option_Name>, <Profile_Option_Value>, <Level SITE/APPL/RESP/USER>, <Level_Value>, <Level_Value_App_id>);ExampleSET SERVEROUTPUT ON SIZE 1000000 DECLARE l_user_id NUMBER; l_resp_id NUMBER; l_resp_app_id NUMBER; l_success BOOLEAN; BEGIN l_u 阅读全文