spool to csv file in oracle

set heading off
set linesize 100 pagesize 0
spool D:\count.csv append
select 'DATE'||','||'COUNT' from dual
union all
select to_char(SYSDATE,'yyyy-mm-dd')||','|| Count(*) from table_name ;
spool off
exit ;