Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / SQL PLUS Session Environment

 

Get and set client information by using

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>