How do I spool to a CSV file using SQL Developer?
<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>