| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: What else can USERENV() do?
A copy of this was sent to johnvue_at_gte.net
(if that email address didn't require changing)
On Sat, 11 Jul 1998 00:54:47 GMT, you wrote:
>I came across an Oracle function USERENV() used as:
>
> userenv('sessionid')
>
>Are there any other valid parameters I can pass to the userenv()
>function besides 'sessionid' ??? Is it documented anywhere?
Userenv is documented in the sql language reference manual, chapter 3, functions....
USERENV
Syntax USERENV(option)
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. The argument option can have any of
these values:
’OSDBA’
’LABEL’
’LANGUAGE’
’TERMINAL’
’SESSIONID’
’ENTRYID’
’CLIENT_INFO’
’LANG’
(see the manual for their descriptions...)
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA
http://govt.us.oracle.com/ -- downloadable utilities
Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Sat Jul 11 1998 - 10:17:53 CDT
 |
 |