Shell Programming and Scripting

end_ct=`sqlplus -s $ORACLE_USER/$ORACLE_PASS@$ORACLE_SID   << EOF
                select description from bravo_statistics
                where trunc(time_stamp)=trunc(sysdate)-1
                and description='END CAT';
EOF`
echo $end_ct;

echo $emtr_cnt;
if [$end_ct=="END CAT"]; then
echo "end_cat"
else
echo "value not found"
fi

if [ $end_ct = "END CAT" ];

if [ $end_ct = "END CAT" ]; then

if [ "$end_ct" = "END CAT" ]; then

if [ "$end_ct" = "END CAT" ]; then
echo $end_ct
else
echo "value not found"
fi

set -xv
if [ "$end_ct" = "END CAT" ]; then
echo "X${end_ct}X"
else
echo "value not found"
fi
set +xv

if [ "$end_ct" -eq "END CAT" ] && [ "$emtr_cnt" = 1 ]; then
  echo $end_ct
else
  echo "value not found"
fi