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