Oracle/PLSQL: UserEnv Function(轉自http://www.techonthenet.com/oracle/functions/userenv.php)

hzh_hu發表於2009-06-19


In Oracle/PLSQL, the userenv function can be used to retrieve information about the current Oracle session. Although this function still exists in Oracle for backwards compatibility, it is recommended that you use the sys_context function instead.

The syntax for the userenv function is:

userenv( parameter )

parameter is the value to return from the current Oracle session. The possible values are:

ParameterExplanation
CLIENT_INFOReturns user session information stored using the DBMS_APPLICATION_INFO package
ENTRYIDAvailable auditing entry identifier
INSTANCEThe identifier number of the current instance
ISDBAReturns TRUE if the user has DBA privileges. Otherwise, it will return FALSE.
LANGThe ISO abbreviation for the language
LANGUAGEThe language, territory, and character of the session. In the following format:
language_territory.characterset
SESSIONIDThe identifier of the auditing session
TERMINALThe OS identifier of the current session
[@more@]

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/95530/viewspace-1023319/,如需轉載,請註明出處,否則將追究法律責任。

相關文章