Quick Search:


	CODE Oracle PL/SQL Code Library


	JOBS Find Or Post Oracle Jobs


	FORUM Oracle Discussion & Chat

The Oracle USERENV Function [Return To Index]

Jump to:

Looking for the original pages? (formerly called "Morgan's Library") You can find them here.

Term: USERENV

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

PSOUG LOGIN
Username:
Password: