Export tables as .csv in Oracle SQL Developer for free?

Asked By clotildec hock 10 points N/A Posted on - 10/04/2012

I have been using Oracle SQL Developer, I have a lot of large tables generated which I would like to export into a .csv format. Is there a free way to do this?

• Status: Open
• Question Views: 1390
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Development Software

Answered By Emil Onoon 0 points N/A #168810

Export tables as .csv in Oracle SQL Developer for free?

Hi

Oracle is an enterprise ready database. To export .CSV using Oracle SQL Developer is very easy. You do not have to mess with PL/SQL codes. One way to do this is to create a Report in SQL Developer and export the results. Once the report is created and ran, right click on the results grid and choose “Export” from the context menu. In the next screen select CSV as the format and enter in the filename.csv and location.

You can also export a single table by right-clicking the table name in the object tree view. Select Export. Select CSV. The Export Data window shows up. Click Format tab. Select Format as: CSV. Enter a file name and location. Click Columns tab. Check the columns you wish to export. Click 'Where' tab and add any criteria needed to filter the data. Click Apply.

About Emil Onoon

Questions
0

Answers
198

Best Answers
58

• Vote Up 0 Vote Down

• Posted on - 10/23/2012
• Question Category: Development Software