Oracle ORA_INVOKING_USERID() Function

Oracle ORA_INVOKING_USERID is a built-in function that returns the identifier of the database user who invoked the current statement or view.

Oracle ORA_INVOKING_USERID Syntax

Here is the syntax for the Oracle ORA_INVOKING_USERID function:

ORA_INVOKING_USERID

Parameters

The Oracle ORA_INVOKING_USERID function does not require any parameters.

Return Value

The Oracle ORA_INVOKING_USERID function returns the identifier of the database user who invoked the current statement or view.

The function returns a NUMBER value.

Oracle ORA_INVOKING_USERID Examples

Here are some examples that demonstrate the usage of the Oracle ORA_INVOKING_USERID function.

Basic Usage

The following statement retrieves the user identifier of the user who invoked the current statement:

SELECT
    ORA_INVOKING_USERID
FROM dual;

Output:

ORA_INVOKING_USERID
______________________
9

Conclusion

Oracle ORA_INVOKING_USERID is a built-in function that returns the identifier of the database user who invoked the current statement or view.