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: Jeremy Ovenden <jovenden_at_hazelweb.co.uk>
Date: Thu, 1 Jul 1999 16:38:18 +0100
Message-ID: <7lg27f$1op$1@gxsn.com>

Anurag Minocha wrote in message <377B7ECD.855D1974_at_synergy-infotech.com>...
>body:
>spool &filename

I think where you have &filename you need &1 - this will map to the first command line parameter

>select * from tab;
>spool off
>
>from the dos prompt i gave
>c:\>sqlplus -s <username/pwd>@database @ test.sql tables.log
>
>It still asks me enter the filename.

s/b OK now

jeremy Received on Thu Jul 01 1999 - 10:38:18 CDT

Original text of this message

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