Definition:
The USERENV is an Oracle provided namespace that describes the current session, and can be used to obtain information about the current Oracle session.
NOTE: This function is deprecated, but still exists in Oracle for backwards compatibility. Oracle recommends that you use the
SYS_CONTEXT function instead.
Example Syntax:
USERENV( parameter )
The parameter is the item value to obtain from the Oracle session. The possible parameter values are:
| Parameter | Meaning |
| CLIENT_INFO |
Returns the user session information stored using the DBMS_APPLICATION_INFO package |
| ENTRYID |
Available auditing entry identifier |
| INSTANCE |
The identifier number of the current instance |
| ISDBA |
Returns TRUE if the user has DBA privileges, FALSE if the user does not. |
| LANG |
The ISO abbreviation for the language |
| LANGUAGE |
The language, territory, and character of the session.
The returned data is supplied in the following format:
language_territory.characterset |
| SESSIONID |
The identifier of the auditing session |
| TERMINAL |
The identifier for the operating system of the current session |
Related Links:
