December 2002
Intermediate to advanced
928 pages
85h 29m
English
USERENV (option)Returns information about the current user as a VARCHAR2. Beginning with the Oracle 8.1.6 release, SYS_CONTEXT may also be used to retrieve these user environment values. For ENTRYID and SESSIONID, the AUDIT_TRAIL initialization parameter must be TRUE, and these variables cannot be used in a distributed environment.