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: