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






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>








29.60.userenv
29.60.1.Use userenv
29.60.2.userenv('sessionid')