Shell Programming and Scripting

#!/bin/bash

# values
GEN_ERR=1 #error 1 code
USER=username
PASS=mypass
SIDORA=oracle.db
LOG=/var/log/failure.log

#Login to the DB
sqlplus -s /nolog <<EOF 
connect $USER/$PASS@$SIDORA

select 1 from dual;

EOF

errorCode=$?    # checks if the last operation (sqlplus) was completed successfully or not
if [ ${errorCode} -ne 0 ]
then
echo "DATE" >> $LOG
exit ${CRED_ERR}
fi

OUTFILE=outfile.txt # Declare a output file
#Login to the DB
sqlplus -s /nolog <<EOF > $OUTFILE
connect $USER/$PASS@$SIDORA
select 1 from dual;
exit;
EOF

if [[ ! -s ${OUTFILE} ]]
then
        echo "$DATE" >> $LOG
        exit ${CRED_ERR}
fi

select 1 my_test_value from dual;

select 'my_test_string' x from dual;

grep '1' inputfile