USER

Syntax

user::=

Text description of user

Purpose

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.

Example

The following example returns the current user and the user's UID:

SELECT USER, UID FROM DUAL;
 
USER                                  UID
------------------------------ ----------
OE                                     33