USERENV

Syntax

Purpose

USERENV returns information of VARCHAR2 datatype about the current session. This information can be useful for writing an application-specific audit trail table or for determining the language-specific characters currently used by your session. You cannot use USERENV in the condition of a CHECK constraint. The argument option can have any of these values:

'ISDBA'	returns 'TRUE' if you currently have the ISDBA role enabled and 'FALSE' if you do not.
'LANGUAGE'	returns the language and territory currently used by your session along with the database character set in this form: language_territory.characterset
'TERMINAL'	returns the operating system identifier for your current session's terminal. In distributed SQL statements, this option returns the identifier for your local session. In a distributed environment, this is supported only for remote SELECTs, not for remote INSERTs, UPDATEs, or DELETEs.
'SESSIONID'	returns your auditing session identifier. You cannot use this option in distributed SQL statements.
'ENTRYID'	returns available auditing entry identifier. You cannot use this option in distributed SQL statements. To use this keyword in USERENV, the initialization parameter AUDIT_TRAIL must be set to TRUE.
'LANG'	returns the ISO abbreviation for the language name, a shorter form than the existing 'LANGUAGE' parameter.
'INSTANCE'	returns the instance identification number of the current instance.
'CLIENT_INFO'	returns up to 64 bytes of user session information that can be stored by an application using the DBMS_APPLICATION_INFO package.
	CAUTION: Some commercial applications may be using this context value. Check the applicable documentation for those applications to determine what restrictions they may impose on use of this context area.
	Oracle recommends that you use the application context feature or the SYS_CONTEXT function with the USERENV option. These alternatives are more secure and flexible. See Also: Oracle8i Concepts. for information on application context. "CREATE CONTEXT" and "SYS_CONTEXT".

Example

SELECT USERENV('LANGUAGE') "Language" FROM DUAL;

Language
-----------------------------------
AMERICAN_AMERICA.WE8DEC