Select the default value from V$SESSION.CLIENT_INFO. : V_SESSION « System Tables Views « Oracle PL / SQL






  1. Oracle PL / SQL
  2. System Tables Views
  3. V_SESSION

Select the default value from V$SESSION.CLIENT_INFO.

    
SQL> SELECT   USERENV('CLIENT_INFO')
  2  FROM     dual;

USERENV('CLIENT_INFO')
----------------------------------------------------------------
1

1 row selected.

SQL>
SQL>








Related examples in the same category

1.Dynamic Performance Views: V$SESSION contains information about each connected user or process in the database
2.Blocked-session details