New answers tagged oracle-sql-developer
0
I'd look at writing a query to produce the comma separated values, taking care to string out any extraneous carriage returns or other funnies that would break the format, especially if you have columns that are free-form text entry and might have all sorts of entries in them. I once saw data for "email_content" that had an example of comma-separated values ...
3
Asuming this is to transport data to an other system. It that case this will work:
set colsep ";"
set linesize 9999
set trimspool on
set heading off
set pagesize 0
set wrap off
set feedback off
set newpage 0
set arraysize 5000
spool you csv_file.csv
select rows from your tables;
spool off
If you don't want a header line, change to heading off
If this is ...
Top 50 recent answers are included
