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> SELECT sys_context('USERENV', 'CURRENT_USER') FROM DUAL;
SYSTEM

SQL> SELECT sys_context('USERENV', 'NETWORK_PROTOCOL') FROM DUAL;
TCP