Oracle 10g, SQLPLUS, unix, passing argument question

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