SQL User function

In Oracle/PLSQL, the user function returns the user_id from the current Oracle session.

Syntax

The syntax for the user function is:

user

Applies To

• Oracle 11g, Oracle 10g, Oracle 9i, Oracle 8i

For Example

select user
into parm_user_ID
from dual;

The variable called parm_user_ID will now contain the Oracle user ID from the current Oracle session.