Category Archives: sys_context

oracle SYS_CONTEXT Examples;

Connect system /oracle@orcl SET SERVEROUTPUT ON SQL> EXEC dbms_output.put_line(sys_context(‘USERENV’, ‘CURRENT_USER’));SYSTEM SQL> EXEC dbms_output.put_line(sys_context(‘USERENV’, ‘SESSION_USER’));SYSTEM SQL> EXEC dbms_output.put_line(sys_context(‘USERENV’, ‘IP_ADDRESS’));192.168.1.2 SQL> SELECT sys_context(‘USERENV’, ‘IP_ADDRESS’) FROM DUAL;192.168.1.2 SQL> EXEC dbms_output.put_line(sys_context(‘USERENV’, ‘NETWORK_PROTOCOL’));tcp SQL> EXEC dbms_output.put_line(sys_context(‘USERENV’, ‘AUTHENTICATION_TYPE’)); DATABASE SQL> SELECT sys_context(‘USERENV’, ‘AUTHENTICATION_TYPE’) FROM DUAL;DATABASE SQL> … Continue reading

Posted in sys_context | Leave a comment