Use shell script parameter in sql script?!

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