SQL Plus - User

Card Puncher Data Processing

About

Where can if find user information in SQL Plus.

Variable

Substitution

The dynamic substitution variable _USER gives the current user

DEFINE _USER
DEFINE _USER           = "GERARD" (CHAR)

System

Their is also a user system variable

show user
USER is "SYS"

You can also use USER in a SQL/PLSQL

select USER from dual;





Discover More
Card Puncher Data Processing
Oracle Database - (Online table) Redefinition (DBMS_REDEFINITION)

Online table redefinition is a mechanism to make table structure modifications without significantly affecting the availability of the table. You can perform online table redefinition: with the Oracle...



Share this page:
Follow us:
Task Runner