$ cat scr1
#!/bin/bash

# ***  Lovely Sethi 08/2013  ***
#  This process executes the BRAVO_MAIN_REFRESH.sql
#
#  This file should be scheduled in CRONTAB to run each Big run.

. ~/.bash_profile 2> /dev/null >&2

sqlplus -s $ORACLE_USER/$ORACLE_PASS@$ORACLE_SID   << EOF > sql_output.txt
                select count(*) from bravo_statistics
                where trunc(time_stamp)=trunc(sysdate)
                and description in ('BEGIN NIT','END MR');
EOF
big_cnt=$(sed -n '4p' sql_output.txt)

if [ $big_cnt -eq 0 ] ; then

  sqlplus -s $ORACLE_USER/$ORACLE_PASS@$ORACLE_SID   << EOF >> sql_output.txt
                select nvl(description,'0') from bravo_statistics
                where trunc(time_stamp)=trunc(sysdate)
                and description='END CAT';
EOF

  sqlplus -s $ORACLE_USER/$ORACLE_PASS@$ORACLE_SID   << EOF >> sql_output.txt
                select count(*) from mrs.bill_cal
                where trunc(actual_run_date)=trunc(sysdate)-19;
EOF

  end_ct=$(sed -n '9p' sql_output.txt)
  emtr_cnt=$(sed -n '14p' sql_output.txt)

  if [ "$end_ct" = "END CAT" ] && [ $emtr_cnt -eq 1 ];  then
    sqlplus $ORACLE_USER/$ORACLE_PASS@$ORACLE_SID @/uv1402/u207/home/bravodba/bestdbscript/sqlscriptfiles/BRAVO_MAIN_REFRESH.sql
    /uv1402/u207/home/bravodba/bestdbscript/shscriptfiles/sendmailanalysisrefresh.sh
    echo "value found"
  fi
fi

$ bash -n scr1
(no output - syntax is valid)