Search Results

Thank you moderator! I am on verge to get this info.. if I succeed, I will paste it here... :) I think its doable but its not easy.. I googled a lot but could not find it anywhere..

I am using korn shell on an AIX machine..
shell script as below:

. /ptma/ptma.profile;
echo $DB_PASS | sqlplus $DB_USER@$DB_SID @/ptma/ActivationCountCheck/ActivationCountCheck.sql;
mail -s...

I have written a shell script that calls below sql file. It is not sending the query data in table in the body of email.

spool table_update.html;
SELECT * FROM PROCESS_LOG_STATS where process =...