Sample script to connect to oracle database

Here is the sample script to connect to oracle database and get value.

sqllog=/tmp/sqllog.dat

spoolout=/tmp/spool.out

sqlplus -s /nolog <<EOF > $sqllog
set term off
set head off
set linesize 300
set feedback off
set trimspool on
set serveroutput on
whenever oserror exit
whenever sqlerror exit sql.sqlcode
connect OraUser/OraPassword@OraName
spool $spoolout
select * from dual;
spool off
exit
EOF
rc=$?

if [[ $rc != 0 ]];then

echo “unable to connect to oracle database”

fi