• 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 / USER Function in Oracle SQL – PLSQL

USER Function in Oracle SQL – PLSQL

November 7, 2012 by techhoneyadmin

The USER function in Oracle SQL / PLSQL is used to retrieve the user id of the current Oracle Session.

Syntax for the USER function in Oracle SQL / PLSQL is:

SELECT USER
FROM table_name;

Example:

Using USER function to retrieve the user name for the current session

SELECT USER
FROM dual; 

Will return the name of the user logged in the current Oracle Session e.g. “System” or “Scott”.


Filed Under: function Tagged With: how to use user function in oracle database query, how to use user function in oracle plsql, how to use user function in oracle sql, syntax and example of user function in oracle database query, syntax and example of user function in oracle plsql, syntax and example of user function in oracle sql, user function in oracle plsql, user function in oracle sql, USERPLSQL, using user function in oracle database query, using user function in oracle plsql, using user function in oracle sql

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