Oracle 10g, SQLPLUS, unix, passing argument question

From: zw <>
Date: Fri, 1 Feb 2008 02:26:28 -0800 (PST)
Message-ID: <>


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 Received on Fri Feb 01 2008 - 04:26:28 CST

Original text of this message