Table of Contents

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;