Need help writing UNIX shell scripts, Please help!

[abhey_1998]

Hi,
I am in need of writing a shell script to read, database table and email the results to a list of users.
Please let me know if I could provide further info.
Please assist.
Thanks,
-Abhey

[chris5126]

hi can you give us any code you have written so far and a few lines of the database and what needs to be in the email format etc

[abhey_1998]

hi can you give us any code you have written so far and a few lines of the database and what needs to be in the email format etc

Hi, thanks for getting back to me.

To log into sql pls ( in the shell script. )
-- get the data.

$ORACLE_HOME/bin/sqlplus -s usr/pwd@database << EOF1 > msgbody
$LOGIN_PSWD
set feedback off
whenever sqlerror exit failure
EOF1

-- send email out.

cat msgbody | mailx -s "Subject:OnlyBody" [e-mail]

[chris5126]

d

[chris5126]

hi what format is the data in within the spreadsheet e.g

name dob address car reg

or

name
dob
address
car reg

etc

and what format do you want the data to be in the email??

[abhey_1998]

Email would go to each sales rep
Subject line would be: commision paid
Body would be:
Commission paid for the following order
order no amt date
123 $2 2/2/08
345 $1 2/3/08 etc....
Please let me know if that helped.