Spooling column headers correctly
Hi,
Im trying spooling a file in DB with below mentioned details.
SET SERVEROUTPUT OFF
set heading on
SET PAUSE OFF
SET FEED OFF
SET PAGES 0
SET LINE 5000
SET VERI OFF
SET TERM OFF
SET TERMOUT OFF
SET TIME OFF
SET UNDERLINE OFF
SET COLSEP ','
SET ECHO OFF
SET TRIM ON
SET TRIMOUT ON
SET TRIMSPOOL ON
set newpage none
spool ${OUTPUT_PATH}/${REPORT_NAME}/${REPORT}_${START_DATE}.csv
@${SCRIPT_PATH}/${REPORT_NAME}/my_query.sql
spool off
exit;
EOF
file .sql has 20 odd columns.
When file is spooled, it shows no columns headers at the top, why is it happening, I dont want to spool column headers separately.