Connecting to Database

Hi,

I want to write a shell script which connects to a Database, executes a set of SQLs and displays a message for every SQL that was run whether any records have been returned or not?

Can anyone help me in this regard?

Appreciate your help and concern.

Thanks,
Dave

try this
http://www.unix.com/unix-dummies-questions-answers/1644-sqlplus-shell-scripting.html