Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> SQL*Plus: can variables be used for control of execution?
I run Oracle v.8.1.7, and I am making a script to be run in SQL*Plus several
times.
This script should be run by one specific user logged on, and I would like
to add some functionality to check whether the person starting the script is
logged on as the user I want her to be, otherwise do not run the commands.
It seems to be possible to use variables in SQL*Plus scripts, so I can
probably put the name of the current user into a variable. But I would like
to terminate the script (EXIT) if the content of that variable is not
identical to one specific value - something like:
IF VAR1 <> 'SUP'
EXIT;
ELSE
.
.
Is it possible in any way to get this functionality into a SQL*Plus script?
Thanks for any help on this,
Randi W
Received on Tue Mar 30 2004 - 02:20:57 CST