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.
0 comments:
Post a Comment