SQL Plus - User

> Procedural Languages > (SQL Plus|SqlCl) (Oracle Database Console)

1 - About

Where can if find user information in SQL Plus.

3 - Variable

3.1 - Substitution

The dynamic substitution variable _USER gives the current user

DEFINE _USER
DEFINE _USER           = "GERARD" (CHAR)
Advertising

3.2 - 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;
lang/sqlplus/user.txt · Last modified: 2017/05/09 16:51 by gerardnico