Oracle UID() Function

Oracle UID is a built-in function that returns the unique identifier of the current user session.

Oracle UID Syntax

Here is the syntax for the Oracle UID function:

UID

Parameters

The Oracle UID function does not require any parameters.

Return Value

The Oracle UID function returns the unique identifier of the current user session.

Oracle UID Example

The following statement shows an example of using the Oracle UID function.

SELECT
    UID
FROM dual;

Output:

   UID
______
     9

Conclusion

Oracle UID is a built-in function that returns the unique identifier of the current user session.