Shell Programming and Scripting

...
...
sqlplus -s ${ORA_CONN_STR} <<EOF

SET TERMOUT OFF
SET HEADING OFF
SET PAGESIZE 50000
SET LINESIZE 500
SET TRIMSPOOL OFF
SET WRAP OFF
SET FEEDBACK OFF
SET ECHO OFF

SPOOL ${CSV_DIR_FILE}

SELECT 'My header text here'
   FROM dual;
   
SELECT TRIM (field1) || ',' ||
       TRIM (field1) || ',' ||
       TRIM (field2) || ',' ||
       TRIM (field3) || ',' ||
       TRIM (field4)
       ....
   FROM <tablename>;
   
EOF
...
...

sqlplus -s ${ORA_CONN_STR} <<EOF >/dev/null

$
$
$ cat tst.sh
#!/usr/bin/bash
ORA_CONN_STR="test/test"
CSV_DIR_FILE="tst.log"
sqlplus -s ${ORA_CONN_STR} <<EOF >${CSV_DIR_FILE}
SET TERMOUT OFF
SET HEADING OFF
SET PAGESIZE 50000
SET LINESIZE 500
SET TRIMSPOOL OFF
SET WRAP OFF
SET FEEDBACK OFF
SET ECHO OFF
SELECT 'My header text here'
  FROM dual;
SELECT c1 || ',' ||
       c1 || ',' ||
       c2 || ',' ||
       c3
   FROM t;
EXIT
EOF
$
$ ./tst.sh
$
$ cat tst.log
 
My header text here
 
1,1,10,a
2,2,20,b
3,3,30,c
4,4,40,d
5,5,50,e
$
$