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
1 | SELECT UID |
2 | FROM dual; |
May return ‘5’ or ’15’ or any other number.