Oracle USER() Function

Oracle USER is a built-in function that returns the name of the current user for the session.

Oracle USER Syntax

Here is the syntax for the Oracle USER function:

USER

Parameters

The Oracle USER function does not require any parameters.

Return Value

The Oracle USER function returns the name of the current user for the session as a VARCHAR2 type value.

Oracle USER Example

The following statement demonstrates the usage of the Oracle USER function:

SELECT
    USER
FROM dual;

Output:

USER
_________
SYSTEM

Conclusion

Oracle USER is a built-in function that returns the name of the current user for the session.