• Skip to primary navigation
  • Skip to main content

Tech Honey

The #1 Website for Oracle PL/SQL, OA Framework and HTML

  • Home
  • HTML
    • Tags in HTML
    • HTML Attributes
  • OA Framework
    • Item in OAF
    • Regions in OAF
    • General OAF Topics
  • Oracle
    • statement
    • function
    • clause
    • plsql
    • sql
You are here: Home / Oracle / function / UID Function in Oracle SQL – PLSQL

UID Function in Oracle SQL – PLSQL

November 28, 2012 by techhoneyadmin

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.


Filed Under: function Tagged With: how to get the id number of the current user using the UID oracle sql plsql function, How to use oracle sql plsql UID function with example, UIDPLSQL, What is oracle sql plsql UID function

Copyright © 2023 · Parallax Pro on Genesis Framework · WordPress · Log in