Oracle/PLSQL: Uid function
In Oracle/PLSQL, the uid function returns the id number for a user's session (the user who is currently logged in).
The syntax for the uid function is:
uid
Applies To:
- Oracle 8i, Oracle 9i, Oracle 10g, Oracle 11g
For example:
select uid
into parm_uid
from dual;
The variable called parm_uid will now contain the id number for the user's session. The value could be 25, for example.
