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

afaik: Not exactly possible in sqlplus. sqlplus will prompt you.

You can however investigate if
accept var_name default 'xyz' prompt 'Enter value for var_name:'

will work for you.
Though you can code something in ksh etc as a wrapper which will easily do this for you.

Anurag

"Massimiliano" <maxim99_at_libero.it> wrote in message news:2c39cc64.0303041153.2d26f994_at_posting.google.com...
> 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 - 22:09:08 CST