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).

Syntax

The syntax for the uid function is:

uid

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

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.