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