Shell Script to execute SQL's

Shell Programming and Scripting
1

Hi people, i need youre help on this.

I need to create an Shell SCript to list in a directory some sql files and then execute them one by one .

Also i need to have Logs from the executed Sql's to send to our costummers.

Can anyone help me on this

Regards,

osramos

2

Oracle example:

cd /path/to/sqlfiles 
find . -name '*.sql' | \
while read file 
do
  sqlplus -s user/pswd@somedb <<EOF
  start $file
EOF
done

Use mailx to send logs, there are a lot of examples on sending email on the forums, see the FAQ as well.

3

is there any way that the log file which is getting generated as PDF file??

Thanks!!