UID Function in Oracle SQL – PLSQL

Oracle SQL / PLSQL uses the UID function to get the id number of the user’s session for the user who is currently logged in.

Orace SQL / PLSQL syntax for the UID function is:

SELECT UID
FROM table_name;

Example: Using Oracle SQL UID function in SQL SELECT Statement

[sourcecode language=”sql”] SELECT UID
FROM dual;
[/sourcecode]

May return ‘5’ or ’15’ or any other number.


Leave a Reply

Your email address will not be published. Required fields are marked *