Use userenv : userenv « SQL PLUS Session Environment « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. SQL PLUS Session Environment
3. 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>