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

 SELECT UID
FROM dual;

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


Tagged , , , . Bookmark the permalink.