Export Data to a CSV File in Oracle

Q

How To Export Data to a CSV File in Oracle?

✍: FYIcenter.com

A

If you want to export data from a table to a file in CSV format, you can use the following steps:

  • Right-click the table name, EMPLOYEES, in the object tree view.
  • Select Export.
  • Select CSV. The Export Data window shows up.
  • Click Format tab.
  • Select Format as: CSV.
  • Enter File as: \temp\MyTeam.csv.
  • Click Columns tab.
  • Check columns: FIRST_NAME, LAST_NAME, MANAGER_ID
  • Click Where tab.
  • Enter Where clause as: MANAGER_ID=100.
  • Click Apply.

Your CSV file, \temp\MyTeam.csv, is ready. Open it, you will see:

"FIRST_NAME","LAST_NAME","MANAGER_ID"
"Gerald","Cambrault","100"
"Lex","De Haan","100"
"Alberto","Errazuriz","100"
"Adam","Fripp","100"
"Michael","Hartstein","100"
"Payam","Kaufling","100"
"Neena","Kochhar","100"
...

CSV files can be open by Microsoft Excel.

 

Introduction to Oracle SQL Developer

⇒⇒Oracle Database Tutorials

2016-10-17, 204👍, 0💬