set echo off set feedback off set heading off set pagesize 0 set linesize 1000 set termout off set trimspool on spool data.csv select col1 || ',' || col2 || ',' || col3 from test_table; spool off exit