Csv Output

set echo off
set feed off
set verify off
set colsep ','
set time off
set timi off
set head off
set trimspool on
set trimout on

spool …csv

— your select statement. i.e. select * from dual;

spool off