|
|
| Re: What does USERENV do? [message #821 is a reply to message #810] |
Wed, 06 March 2002 03:55  |
pratap kumar tripathy
Messages: 660
Registered: January 2002
|
Senior Member |
|
|
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.
CLIENT_INFO
-----------
CLIENT_INFO returns up to 64 bytes of user session information that can be stored by an application using the DBMS_APPLICATION_INFO package.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
