Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / SQL PLUS Session Environment

 

Use userenv

SQL> SQL> exec dbms_application_info.set_client_info('KING'); PL/SQL procedure successfully completed. SQL> SQL> select userenv('CLIENT_INFO') from dual; USERENV('CLIENT_INFO') ---------------------------------------------------------------- KING SQL>