Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Any trick for preventing sqlplus asking value for &1???
Hi,
I wrote a scritp which I execute from sqlplus in this way:
@script.sql <parameter>
In the script I use the parameter (&1).
My question is:
is it possibile to execute the script without passing the parameter
and using some default value?
Infact, I must execute the script with or without the parameter. In
case I don't pass parameter I wouldn't want sqlplus asking for it.
Tia
Max Received on Tue Mar 04 2003 - 13:53:15 CST
![]() |
![]() |