Reputation: 21
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
Upvotes: 2
Views: 19080
Reputation: 1163
-- 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
Upvotes: 2