Re: Oracle 10g, SQLPLUS, unix, passing argument question

From: gazzag <gareth_at_jamms.org>
Date: Fri, 1 Feb 2008 05:15:26 -0800 (PST)
Message-ID: <aa022475-ddab-4367-884f-13d941460e2a@e6g2000prf.googlegroups.com>


On 1 Feb, 10:26, zw <MPC8..._at_gmail.com> wrote:
> Hi
>
> 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
> variables
>
> Are there books out there that show how to use unix/linux shell
> variables with sqlplus scripts ?
>
> Thanks

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

Original text of this message