title: How do I spool to a CSV file using SQL Developer?
body: <p>i have this kind of script that i want to spool the final output to a csv file. can you please help?</p>
  
  <pre><code>with first_sub as
  select etc
  ,
  second_sub as
  select etc
  
  select first_column from first_sub* first_column from second_sub etc.
  </code></pre>
  
  <p>......................................
  ..basically, i have 2 or more sub queries that i do maths on in my 'final query'
  what i need is to be able to spool the output as a csv.</p>
  
  <p>sorry but im not able to post any specific code</p>
  
  <p>ok, to clarify, i CAN ALREADY spool a 'Simple' query 
  i.e `select *from employees'</p>
  
  <p>what i have is like this </p>
  
  <pre><code>    with sub_1 as 
      select * from employees
      ,
      sub_2 as 
      select * from other_employees
  
  select something from sub1 * something_else from sub_2
  </code></pre>
  
  <p>The last bit is what i want to take out to a .csv file please</p>