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 -> Re: passing values to sql script freom dos prompt please help! need it urgently

Re: passing values to sql script freom dos prompt please help! need it urgently

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 30 Jun 1999 19:12:45 +0200
Message-ID: <930762710.28923.0.pluto.d4ee154e@news.demon.nl>


Hi Anurag
In your sqlplus script you can reference &1 &2 etc upto 8 or 9 it is advisable to assign those to meaningful variables immediately. Then just call
sqlplus -s <username/pwd>@database @<scriptname> parm1 parm2 etc etc.

Hth,

Sybrand Bakker, Oracle DBA

Anurag Minocha <anurag_at_synergy-infotech.com> wrote in message news:3779EE2F.E2308F8A_at_synergy-infotech.com...
> Hi,
> How do I pass values to SQL script using DOS batch file variable like %1
>
> , %2..
>
> anurag
>
> reply at
> anurag_at_synergy-infotech.com.
>
>
>
Received on Wed Jun 30 1999 - 12:12:45 CDT

Original text of this message

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