UNIX for Beginners Questions & Answers

#!/usr/bin/env bash

tables=(geo_JOB geo_JOB1)

(
cat <<EOF
SET HEADING ON
SET WRAP OFF
SET TRIMSPOOL ON
SET TRIMOUT ON
SET PAGESIZE 50000
SET COLSEP ","
SET LINESIZE 500
SET NEWPAGE NONE
SET FEEDBACK OFF
SET VERIFY OFF
SET UNDERLINE OFF
EOF

for i in "${tables[@]}"
do
cat<<EOF

SPOOL $i.csv
SELECT * FROM $i ;
SPOOL OFF
EOF

done
echo "EXIT" 
) | sqlplus -s dev01/password@dEV3 > somelog.txt

SET HEADING ON
SET WRAP OFF
SET TRIMSPOOL ON
SET TRIMOUT ON
SET PAGESIZE 50000
SET COLSEP ","
SET LINESIZE 500
SET NEWPAGE NONE
SET FEEDBACK OFF
SET VERIFY OFF
SET UNDERLINE OFF

SPOOL geo_JOB.csv
SELECT * FROM geo_JOB ;
SPOOL OFF

SPOOL geo_JOB1.csv
SELECT * FROM geo_JOB1 ;
SPOOL OFF
EXIT