Re: PASSING A PARAMETER FROM KORN SHELL (NEWBIE)

Hello,

     If you have your SELECT statement in a .sql script, you can issue the following:

sqlplus user/passwd_at_alias @script.sql $STFIPS

Then, in your script.sql the parameter &1 will be assigned the value of $STFIPS and can be used in the WHERE clause. I hope this helps.

Cary

In article <36E7132B.4386F845_at_worldnet.att.net>,   j.gober_at_worldnet.nospam.att.net wrote:
> This is a multi-part message in MIME format.
> --------------00067491095A877E265ABD30
> Content-Type: text/plain; charset=us-ascii
> Content-Transfer-Encoding: 7bit
>
> To the great Oracle of Oracle:
>
> I have the need to pass a UNIX logical parameter called STFIPS (example:
> STFIPS=35) which is identified in a Korn shell into a where clause in an
> SQL. The answer has to be simple but not to us newbies who have never
> done it before.
>
> All help is appreciated
>
> John 'the newbie' Gober
>
> --------------00067491095A877E265ABD30
> Content-Type: text/x-vcard; charset=us-ascii;
> name="j.gober.vcf"
> Content-Transfer-Encoding: 7bit
> Content-Description: Card for John Charles Gober
> Content-Disposition: attachment;
> filename="j.gober.vcf"
>
> begin:vcard
> n:Gober;John Charles
> x-mozilla-html:TRUE
> adr:;;8105 Carlyle Place;Alexandria;VA;22308;USA
> version:2.1
> email;internet:j.gober_at_worldnet.att.net
> x-mozilla-cpt:;0
> tel;work:301-457-3830
> fn:John Charles Gober
> end:vcard
>
> --------------00067491095A877E265ABD30--
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Mar 11 1999 - 10:51:56 CST