I need to export some data into a
spreadsheet format using a csv file. How can I export
into a CSV file?
Answer: There are many methods for
exporting data into CSV format:
1 - SQL Developer:
Oracle SQL Developer can quickly export to a csv file.
2 - Vanilla SQL:
You can write standard SQL to export a comma-delimited flat
file from SQL*Plus using the spool command:
set heading off
col1|','||col2 from my_tables;
set colsep ','
select * from my_table;
3 - PL/SQL: This approach has the
benefit of allowing you to copy all Oracle tables in a
schema into csv spreadsheet files. First you create this procedure and then
use the code below to dump all tables into a csv file.
This will export all files in a schema into a csv format.
all files in a schema into csv file Tips
Get the Complete
Oracle SQL Tuning Information
The landmark book
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
for 30% off directly from the publisher.