Get and set client information by using: dbms_application_info.set_client_info and sys_context : CONTEXT « SQL PLUS Session Environment « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. SQL PLUS Session Environment
  3. CONTEXT
SQL>
SQL> exec dbms_application_info.set_client_info('KING');

PL/SQL procedure successfully completed.

SQL>
SQL> select sys_context('userenv','client_info') from dual;

SYS_CONTEXT('USERENV','CLIENT_INFO')
--------------------------------------------------------------------------------
KING

SQL>








29.38.CONTEXT
29.38.1.SYS_CONTEXT ('WEB_CTX','WEBUSER')
29.38.2.Get current user, session user and current schema by using sys_context
29.38.3.Get and set client information by using: dbms_application_info.set_client_info and sys_context
29.38.4.use sys_context in where statement