IF APEX_ACL.HAS_USER_ROLE( p_application_id => NV('APP_ID'), p_user_name => V('APP_USER'), p_role_static_id => 'ADMINISTRATOR' ) THEN return q'~ select ID, PROGRAM_ID, PROGRAM_MANAGER, ASSGINED_TO, STARTING_DATE, FREQUENCY, INTERVAL, RUN_EVERY_HOURS, REMAINING_HOURS_TO_RUN, IS_APPROVED from ASSESSMENT_PLANS ~'; ELSE return q'~ select ID, PROGRAM_ID, PROGRAM_MANAGER, ASSGINED_TO, STARTING_DATE, FREQUENCY, INTERVAL, RUN_EVERY_HOURS, REMAINING_HOURS_TO_RUN, IS_APPROVED from ASSESSMENT_PLANS where PROGRAM_MANAGER = :APP_USER ~'; END IF;
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter