Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

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>