Re: Pass unix variable to sqlplus
From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Fri, 23 Jan 2004 09:21:31 +0100
Message-ID: <buqkvf$dji$1_at_news3.tilbu1.nb.home.nl>
Date: Fri, 23 Jan 2004 09:21:31 +0100
Message-ID: <buqkvf$dji$1_at_news3.tilbu1.nb.home.nl>
Vincento Harris wrote:
> Oracle 8.1.7.4 on Hp Unix 11i
> I am attempting to pass unix parameters on to sql plus
> I did read on technet that with 9i it is very straightforward
>
> Example script name whoisit
> Pass sid 23
> whoisit 23
> returns
>
>
> Vincento .....
>
> Thanks for your time
>
> Vince
sqlplus uid/paswd_at_connect @script param1[..param2]
script:
&1 == param1, &2 == param2, etc
SQL*Plus Users Guide & Reference
-- Regards, Frank van BortelReceived on Fri Jan 23 2004 - 09:21:31 CET