Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Use shell script parameter in sql script?!

Use shell script parameter in sql script?!

From: Jack Zhu <jackzhu_at_monmouth.com>
Date: Mon, 13 Sep 1999 23:24:15 -0400
Message-ID: <37DDBFDF.D73DF23D@monmouth.com>


A shell script: "sch", I want to use it as "sch <parameter 1>". And in "sch" script, I also use 'sqlplus' to call a sql script which is "my.sql".

My question is, if in 'my.sql' I want to access the shell parameter(s). What's the syntax?

Can I use: instr('$1', '.') to access the first shell parameter?

Thanks! Received on Mon Sep 13 1999 - 22:24:15 CDT

Original text of this message

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