exporting oracle data to csv

[LKBrwn_DBA]

Try this:

set termout off
set hea off
set pagesize 0
col crdt new_value today
select to_char(sysdate,'YYYYMMDD') crdt from dual;
spool c:\whatever_&&today..csv

select a.a||','||a.b||','||a.c
from a
where a.a="whatever";

spool off