This Oracle tutorial explains how to use the Oracle/PLSQL USER function.
The Oracle/PLSQL USER function returns the user_id from the current Oracle session.
The syntax for the Oracle/PLSQL USER function is:
USER
There are no parameters or arguments for the USER function.
select USER from dual;