Oracle - Export Data to a CSV File in Oracle

Home > Oracle

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

2019-01-26, 535👍, 0💬

Export Data to an XML File in Oracle
How To Export Data to an XML File in Oracle? If you want to export data from a table to a file in XML format, you can use the following steps: Right-click the table name, EMPLOYEES, in the object tree view. Select Export. Select XML. The Export Data window shows up. Click Format tab. Select Format a... 2019-01-12, 573👍, 0💬

Create a Stored Procedure Interactively in Oracle
How To Create a Procedure Interactively in Oracle? If you want to create a stored procedure interactively, you can use the following steps: Open you connection name, like Local_XE. Right-click Procedures. Select Create PROCEDURE. The Create Procedure window shows up. Enter Name as: Hello Click OK. T... 2019-01-12, 539👍, 0💬

File Formats Supported on Export Data in Oracle
How Many File Formats Are Supported to Export Data in Oracle? Oracle SQL Developer can allow to export table data into files in the following formats: TXT - Tab delimited fields file format. CSV - Comma Separated Values (CSV) file format. LOADER - File format used by SQL*Loader. XML - XML file forma... 2019-01-26, 537👍, 0💬

Export Data to a CSV File in Oracle
How To Export Data to a CSV File in Oracle? 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... 2019-01-26, 536👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.