Re: Oracle 10g, SQLPLUS, unix, passing argument question
Date: Fri, 1 Feb 2008 05:15:26 -0800 (PST)
On 1 Feb, 10:26, zw <MPC8..._at_gmail.com> wrote:
> Could someone give 2 simple examples using sqlplus command line on
> 1 - how to pass unix shell argument/variables to a sql file, which
> will use the arguments (eg $1, $2, etc) to execute sql statements.
> 2 - how to retrieve variable values in sql file and pass to unix shell
> Are there books out there that show how to use unix/linux shell
> variables with sqlplus scripts ?
Sybrand gave you an excellent answer. However, are you aware of the AskTom website? I searched it with "sqlplus shell script" as the search criteria: http://asktom.oracle.com/pls/asktom/f?p=100:1:2220814443661870::NO:RP::
HTH -g Received on Fri Feb 01 2008 - 07:15:26 CST