title: Remove Blank Line In Between Select Queries When Spooling to CSV File
body: <p>I'm using oracle sql developer in order to spool some data to a csv file.  So far I have this in one file:</p>
  
  <pre><code>SET head OFF;
  SET echo OFF; 
  SET termout OFF; 
  SET verify OFF; 
  set colsep ,
  set pagesize 0
  set feedback off
  @sandbox.sql
  </code></pre>
  
  <p>Sandbox.sql contains this:</p>
  
  <pre><code>spool "C:\TEMP\test.csv"
  select 'Date,Average' from dual;
  select to_char(rollup_time, 'mm/dd/yyyy'), average from sample_table
  order by 1;
  spool off;
  </code></pre>
  
  <p>This produces some csv file that looks like this:</p>
  
  <p>Date    Average</p>
  
  <p>1/1/2012    900 <br />
  1/2/2012    910</p>
  
  <p>I want to get rid of the blank line that follows the column headings, but I cannot set trimspool on (option does not exist) and union all fails to work because the data types are not the same.  Does anyone know how to remove that blank line in oracle's sql developer environment?</p>