USER

The Oracle and PL/SQL USER function returns the user id from the current Oracle RDBMS session.

The general format is:

USER

Example 1:

select USER from dual;

returns:

myuser