Export Oracle Data to CSV using SQL*Plus

SQL> SET NEWPAGE NONE

SQL> SET UNDERLINE OFF

SQL> SET COLSEP ',' 

SQL> SET PAGESIZE 0
SQL> SET LINESIZE 9999

SQL> SET FEEDBACK OFF

SQL> SET HEADING OFF

SQL> SPOOL ABC_YYYYMMDD.CSV

SQL> select * 

from ABC 

where 1=1

and SNAPSHOT_DATE='19-MAR-2013'

;

SQL> SPOOL OFF