SQL report template

report.sql

set echo off
set embedded  on
set feedback  off
set heading   off
set linesize  2000
set pages     0
set recsep    off
set termout   off
set trim      on
set trimspool on
set wrap      off
set verify    off
spool &1.;


select 'MOBIELNUMMER|INLOGTIJD|TOEGANGSTYPE' from dual

-- do some queries

spool off

-- restore settings
set termout
set feedback on

exit