Export CSV from Oracle: Quick Guide

1 year ago
Ava Mitchell
2 minutes

To export a CSV file in Oracle database, you can use the following method:

  1. Plus tool:
    SQL can be utilized.
SET COLSEP ','
SET LINESIZE 1000
SET PAGESIZE 0
SPOOL output.csv
SELECT * FROM table_name;
SPOOL OFF
  1. Utilizing the PL/SQL Developer tool, connect to the Oracle database and run SQL queries to export the results as a CSV file. In the query results window, right-click on the result set, choose “Save As”, and select the CSV format.
  2. Utilize the SQL Developer tool to connect to an Oracle database, run SQL queries, and export the results as a CSV file. Right-click on the query result in the results window, select “Export,” and choose CSV format.
  3. Export using external tables and data pump:
    First, create an external table and import the query results into this external table. Then, use the data pump to export the external table data in CSV format. For example:
CREATE TABLE ext_tab
(
  col1 NUMBER,
  col2 VARCHAR2(50),
  col3 DATE
)
ORGANIZATION EXTERNAL
(
  TYPE ORACLE_LOADER
  DEFAULT DIRECTORY ext_dir
  ACCESS PARAMETERS
  (
    RECORDS DELIMITED BY NEWLINE
    FIELDS TERMINATED BY ','
    MISSING FIELD VALUES ARE NULL
  )
  LOCATION ('output.csv')
);

You can export query results from Oracle database to a CSV file using any method.

bannerAds