Tuesday, February 23, 2016

Oracle Database - Export table data to a CSV file by using Oracle SQL Developer

If you want to export data from a table to a CSV file is done by using below steps :

STEP :-1 Right click on table name and click on export.

STEP :-2 Click on Export data check box and select Format as csv and finally provide the csv file locaton.

STEP :-3 Select the columns which you want to write to csv file and there is a provision to provide the condition in Object Where section.

STEP :-4 Finally click on Finish.

STEP :-5 Open the exported csv file and check the data.

No comments:

Post a Comment

back to top