select USER from dual;
will retrieve the user if it is used inside of a stored procedure, package or even trigger.
select USER
into variable
from dual;
will insert USER into a variable, variable must be declared
default value may be USER or :=USER for the field.
Hope this helps.
Sal
|