1

Passing multiple column values to UNIX variable

view story
linux-howto

http://www.unix.com – Code: sqlplus -s $USER_ID@$SID/$PWD<<EOF>sql_1.txt  set feedback off  set heading off  select  114032 as c_1 from dual ;  EOF  for i in `cat sql_1.txt`  do  sh script_1.sh  $i Currently i am passing one column value to the single unix variable. How can i pass the values from 2 columns Code: sqlplus -s $USER_ID@$SID/$PWD<<EOF>sql_1.txt  set feedback off  set heading off  select  114032 as c_1 ,sysdate c_2  from dual ;  EOF  sh script_1.sh $col_1_value  $col_2_value I a (HowTos)