|Oracle9i SQL Reference
Release 2 (9.2)
Part Number A96540-02
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
USER functions identify the user on your local database. You cannot use these functions in the condition of a
The following example returns the current user and the user's UID: