Oracle8i SQL Reference Release 2 (8.1.6) A76989-01 |
|
Functions, 113 of 121
USER
returns the name of the session user (the user who logged on) with the datatype VARCHAR2
. Oracle compares values of this function with blank-padded comparison semantics.
In a distributed SQL statement, the UID
and USER
functions identify the user on your local database. You cannot use these functions in the condition of a CHECK
constraint.
SELECT USER, UID FROM DUAL; USER UID ------------------------------ ---------- SCOTT 19
|
![]() Copyright © 1999 Oracle Corporation. All Rights Reserved. |
|