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:

ParameterMeaning
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:
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 141 users online    © 2009 psoug.org
PSOUG LOGIN
Username: 
Password: 
Forgot your password?