I've two documents: doc1.lst and doc 2.lst I want to take the content of each line and put it as parameters for my SQL query.
I tried something like this, please correct me
file=doc1.lst while read line do p1=$line; file=doc2.lst while read line do p2=$line; sqlplus64 $User/$Pass@$ORACLE_SID << EOF2 @update.sql p1 p2 done < echo "Ok" done < echo "Ok" EOF2
The thing is that I want to take the value of each line and put it as a parameter (p1 and p2) to be able to update my table as seen in the sqlplus query.
For a better understanding my file doc1.lst looks like :
AAA ABC EDF
And my file doc2.lst :
30 10 30
I want to take those values to update my table.