shell script to pass table name as a parameter in sqlplus?
<p>I have a file called table.txt which stores the table names. I want the sql update query to take the table name one by one from my table.txt file. My code is as follows:</p>

<pre><code>while read LINE1; do
`sqlplus username/pwd@tname &lt;&lt;END |sed '/^$/d'
set head off;
set feedback off;
update &amp;LINE1 set enterprise_id = '1234567890' where enterprise_id is NULL;
update &amp;LINE1 set sim_inventory_id ='1234567890';
COMMIT;
exit;
END`
done &lt; table.txt
</code></pre>

<p>it gives an error sqlplus not found. Can you please tell what is wrong?</p>