Oracle/PLSQL: User function
In Oracle/PLSQL, the user function returns the user_id from the current Oracle session.
The syntax for the user function is:
user
Applies To:
- Oracle 8i, Oracle 9i, Oracle 10g, Oracle 11g
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.