set termout off trimspool on echo off verify off autoprint off serveroutput off arraysize 1000 pagesize 0
set linesize <minimum value to fit your lines>
set long <minimum value to fit your LONG/xLOB>
set longchunsize <your linesize>
set numwidth <minimum size to fit your number with default format>
set colsepchar '<the column separator character you want>'
col <col> format <minimum format to fit your column for each column>
...
spool <your file>
select ...
spool off

set timing on
BEGIN

  FOR rec in (your query here) LOOP

    NULL;

  END LOOP;

END;
/