The perfect SQLPLUS script.

spool.sql

SET TRIMSPOOL ON
SET TRIMOUT ON
SET HEADSEP OFF
SET ECHO OFF
SET VERIFY OFF
SET TERMOUT ON
SET HEADING OFF
SET PAGESIZE 0
SET FEEDBACK OFF
SET NEWPAGE NONE
SET LINESIZE 9999
SET FEEDBACK OFF
SET SQLPROMPT ''
SET PAUSE OFF
SET TERM OFF

--FILENAME
SPOOL OUTPUT.CSV

--HEADERS
SELECT CONCAT('"','COLA')||'","'||'COLB'||'","'||CONCAT('COLC','"') FROM DUAL;

--DATA
SELECT CONCAT('"',COLA)||'","'||COLB||'","'||CONCAT(COLC,'"') FROM TABLE;