Hello,
I have a script to run a list of customer information, but it not work. can anyone help below:
echo "Please input list to check customer detail:"
read list
for file in 'cat $list.txt'
do
echo "select cuname as "FROM CUNAME", invo_num as "RECS", total_amount as "AMOUNT", tax_amount as "TAX", CUSTOMERNAME as "INTO CUSTOMER", status, original_amount from cuname_2 where CUNAMEin '$file' ;"|sqlplus4 >> output.txt
done
The list look like:
John
Marry
peter
tom
The script cannot read the list correctly.....
Thank you.