I tried something like this
Code:
#!/bin/bash
exec<inputfilename
while read line
do
sqlplus -s username/passwd@$dbname >> output file <<!
select * from table where fieldname='$line'
/
!
done
But the output file just contains the details about the sqlplus command. Do i need to use sppol here?
---------- Post updated at 07:21 AM ---------- Previous update was at 07:11 AM ----------
I tried something like this
Code:
#!/bin/bash
exec<inputfilename
while read line
do
sqlplus -s username/passwd@$dbname >> output file <<!
select * from table where fieldname='$line'
/
!
done
But the output fiel only contains the details of sqlplus command and nothing else. Do i need to use
spool here?
