Skip to Main Content

Breadcrumb

Warning

Before you submit your comment...

Remember - this is about feedback to the original question. AskTOM is about building a strong Oracle community, not stealing time away from others needing assistance by sneaking in a brand new question under the guise of "Comment".

If your comment requires a response that might include a query, please supply very simple CREATE TABLE and INSERT statements. Nice simple scripts so we can replicate your issue simply.

Remember to take a look at Legal Notices and Terms of Use before supplying a comment...

Don't forget, your comments are public. If you want to send a comment to just the AskTOM team, please use the feedback option

Comment

Highlight any SQL, PL/SQL, or fixed-width text and click the <code> button
 (will never be published or used to spam you)

Question and Answer

Chris Saxon

Thanks for the question, Volkenand.

Asked: January 16, 2017 - 3:49 pm UTC

Last updated: January 18, 2017 - 3:03 pm UTC

Version: 4.0.01.14

Viewed 100+ times

You Asked



From sql-developer window:
how it is possible to get every column value from SQL select to csv file in a seperate column in CSV

currently the whole output is in column A for every data set, when I click in Excel on the line, I see it in the view (White space) in the upper part of the window.

my script

set COLSEP  | 
set verify off
set feedback off
set trimspool on
spool on

set term off
set feed off

--spool h:\Dokumente\SL2-DST-frei-1-9-gewerkschaft.xls
--spool W:\SG-323\TeamZentraleKatalogredaktion\+_vk\Sonderlocken-u-RU\Excel-csv-txt\dst_polizei201701.txt
spool W:\SG-323\TeamZentraleKatalogredaktion\+_vk\Sonderlocken-u-RU\Excel-csv-txt\SL2-DST-frei-1-9-gewerkschaft-q4.csv

select * from DST order by DSTSCHL;


spool off
--Einstellungen für spool zurücknehmen
set verify on
set feedback on

and Chris said...

You can read about formatting query output for CSV at:

https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:9518534700346581975

Rating

  (2 ratings)

Is this answer out of date? If it is, please let us know via a Comment