Clear the heading in Oracle spool
use this:
#!/bin/ksh
CONNECT_STRING=dbapp/dbapp@inst
SQLPLUS_SETTINGS="SET PAGESIZE 1000 LINESIZE 500 ECHO OFF TRIMS ON TAB OFF FEEDBACK OFF HEADING OFF"
SQL_RESULT=`sqlplus -s ${CONNECT_STRING} << EOF
${SQLPLUS_SETTINGS}
select sysdate from dual;
exit;
EOF`
echo $SQL_RESULT >output_file
The command you need is:
SET ECHO OFF
However, it only works for code run from scripts, not command entered interactively. You would create a script file like this (e.g. called test.sql):
SET HEADING OFF FEEDBACK OFF ECHO OFF PAGESIZE 0
SPOOL D:\TEST.TXT
SELECT SYSDATE FROM DUAL;
SPOOL OFF
Then in SQL Plus run it like this:
SQL> @test
I added PAGESIZE 0 to the SET command to remove the blank line you otherwise get before the date in the output file.