How to export multiple tables in oracle into multiple .csv files in Oracle SQL developer

Question

I am trying to export multiple tables to individual .csv files (approximately 70 tables need to be exported) in oracle SQL Developer. As of right now, I am running through this process

Run Query

SELECT * FROM TABLE;

From the result window, click "Export Query Results", choosing the encoding and delimiter and saving it as a .csv

This is a lengthy process, and takes around a minute per table (lots of information!), I can't help but think there has to be an easier, more efficient way of doing this. I just can't find any information.

Answer 1

Tools - Database Export

Pick your file format (csv) and directory.

I have Excel shown in the picture, but there's a dozen formats to choose from, including delimited and CSV. If you want European CSV (;), pick delimited and change the delimiter to ;

Then pick your 70 tables.