Re: Any trick for preventing sqlplus asking value for &1???

Massimiliano wrote:

> 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

SQL> SET DEFINE OFF Daniel Morgan Received on Tue Mar 04 2003 - 16:15:00 CST