Oracle9i SQL Reference Release 2 (9.2) Part Number A96540-02 |
|
|
View PDF |
userenv::=
Note:
|
USERENV
returns information 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-3 describes the values for the parameter
argument.
All calls to USERENV
return VARCHAR2
data except for calls with the SESSIONID
, ENTRYID
, and COMMITSCN
parameters, which return NUMBER
.
Parameter | Return Value |
---|---|
|
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. See Also:
|
|
|
|
|
|
|
|
language_territory.characterset |
|
|
|
|
The following example returns the LANGUAGE
parameter of the current session:
SELECT USERENV('LANGUAGE') "Language" FROM DUAL; Language ----------------------------------- AMERICAN_AMERICA.WE8DEC