How do I spool to a CSV file using SQL Developer?

Question

i have this kind of script that i want to spool the final output to a csv file. can you please help?

with first_sub as
select etc
,
second_sub as
select etc

select first_column from first_sub* first_column from second_sub etc.

...................................... ..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.

sorry but im not able to post any specific code

ok, to clarify, i CAN ALREADY spool a 'Simple' query i.e `select *from employees'

what i have is like this

    with sub_1 as 
    select * from employees
    ,
    sub_2 as 
    select * from other_employees

select something from sub1 * something_else from sub_2

The last bit is what i want to take out to a .csv file please

Solution

-- SQL developer You can use /*csv*/ hint in SQL developer. As @Aleksej suggested, you can see the linked thread for further options.

select /*csv*/ * from employees; 

--SQL Plus

set feedback off
set heading on
set underline off
set colsep ','

spool 'mytab.csv'
select * from tab;
spool off