Oracle Spool CSV Export Guide

1 year ago
Jackson Davis
1 minute

To export data with commas in Oracle using spool, you can use the following method:

  1. Set the output format to CSV format.
SET COLSEP ','
  1. Enable spooling function and export data to a CSV file.
SPOOL file_name.csv
SELECT column1, column2, column3
FROM table_name;
SPOOL OFF

The exported data will be separated by commas and saved to the specified csv file.

bannerAds