Oracle APEX user on Oracle Trigger
APEX_APPLICATION.G_USER
SYS_CONTEXT ('APEX$SESSION', 'APP_USER')
v ('APP_USER')
INSERT INTO audit_table (CHANGE_MESSAGE,
CHANGED_BY,
CHANGED_DATE)
VALUES ('Some message',
COALESCE (APEX_APPLICATION.G_USER, USER),
CURRENT_DATE);
INSERT INTO CHECKING (VERIFY_MODE,STD_ID,NAME,REMARKS,SDATE,COMPANY_ID,CHECKED_BY) VALUES('MANUAL',:NEW.STUDENT_ID,:NEW.FIRST_NAME||' '||:NEW.LAST_NAME,:NEW.CHECKING_REMARKS,SYSDATE,'AUW',V('APP_USER'));
**Observe, region “With SYS_CONTEXT” consistently takes less time to render, where as, region “With V Function” takes more time to render.**