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 from dos prompt

Re: passing values to sql script from dos prompt

From: <sybrandb_at_my-deja.com>
Date: Tue, 29 Jun 1999 10:07:49 GMT
Message-ID: <7la5th$c4j$1@nnrp1.deja.com>


In article <377868FB.9F372E34_at_synergy-infotech.com>,   Anurag Minocha <anurag_at_synergy-infotech.com> wrote:
> 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.
>
>

Hi Anurag,
sqlplus supports arguments on the command line by using the &1, &2 and so on substitution variables.
So you could get something like
sqlplus -s <username/password_at_database> @script.sql "feature implemented in sqlplus only".

Hth,

--
Sybrand Bakker, Oracle DBA

All standard disclaimers apply


Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Jun 29 1999 - 05:07:49 CDT

Original text of this message

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