Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: passing values to sql script freom dos prompt please help! need it urgently
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