So, i'm storing the values of the first column returned from a sql query in a variable(
var)..it's supposed to be an array type, because the sql query returns multiple rows, and later,these values would be used in a command.
I'm not sure how to run the same command one after the other with different variables in a shell script.
var=`app/oracle/product/10.2.0/bin/sqlplus -s user/passwd<< !EOF! set pages 0 echo off feed off timing off select entity_name,uid,set_date from table_name; exit !EOF!`
The command to be run looks like:
X=$var Y=`date` ./test.sh