Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Any trick for preventing sqlplus asking value for &1???

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

From: Massimiliano <maxim99_at_libero.it>
Date: 4 Mar 2003 11:53:15 -0800
Message-ID: <2c39cc64.0303041153.2d26f994@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 - 13:53:15 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US