Oracle9i SQL Reference Release 1 (9.0.1) Part Number A90125-01 |
|
Functions, 158 of 166
userenv::=
userenv
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. Table 6-11 describes the values for the parameter
argument.
Parameter | Return Value |
---|---|
' |
|
|
|
|
Oracle recommends that you use the application context feature or the See Also: - Oracle9i Database Concepts for information on application context |
' |
|
' |
|
' |
|
' |
|
' |
language_territory.characterset |
' |
|
' |
|
The following example returns the LANGUAGE
parameter of the current session:
SELECT USERENV('LANGUAGE') "Language" FROM DUAL; Language ----------------------------------- AMERICAN_AMERICA.WE8DEC
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|