Shell Programming and Scripting

#!/bin/bash
export MAILLIST="xyz@yahoo.com"
cd <path_to_the_script_perf_report.sql>
sqlplus / as sysdba @perf_report.sql
if [ `cat /<path_to_the_script/*MONTHLY*REPORT*.lst|wc -l` -gt 0 ]
then
  cat <path_to_the_script/*MONTHLY*REPORT*.lst > /<path_to_the_script/ perf_report.out
  mailx -s "Perf Report Output" $MAILLIST < /<path_to_the_script/ perf_report.out
fi

if [ `ls -1 /<path_to_the_script/*MONTHLY*REPORT*.lst|wc -l` -gt 0 ]

ls <path_to_the_script/*MONTHLY*REPORT*.lst > /<path_to_the_script/ perf_report.out

cat <path_to_the_script/*MONTHLY*REPORT*.lst > /<path_to_the_script/ perf_report.out

function mailme 
{ 
#  set -x 
   #  This function will forward any local file as an e-mail attachment... 
   #     -> currently only provides a text-formatted attachment. 
   FILE="${1}" 
   ATTACHMENT="${1##*/}" 
   TO="${2:-foo@bar.com}" 
   SUBJECT="MailMe: ${FILE}" 

   if    [[ -z ${FILE} ]] \
      || [[ -z ${ATTACHMENT} ]] 
   then 
      echo "MailMe needs a file to attach..." 
      exit 
   fi 

   print "Mailing: ${ATTACHMENT}... " 2>/dev/null 
   uuencode ${FILE} ${ATTACHMENT} |mailx -s "${SUBJECT}" ${TO} 

   return 
}