Oracle APEX user on Oracle Trigger

  1. APEX_APPLICATION.G_USER
  2. SYS_CONTEXT ('APEX$SESSION', 'APP_USER')
  3. 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.**

Questions