USERID

(Read-only) The USERID option holds the user ID for the current Oracle Database session.

Data type

TEXT

Syntax

USERID

Notes

USERID Option and SYSINFO(USER) Function

The value of USERID is also the value that SYSINFO(USER) returns.

Examples

Example 24-26 Displaying the Session User ID

This statement displays the Oracle user ID associated with the current session.

SHOW USERID