Exporting a Database using Oracle SQL Developer
Wrong, I'm afraid. You've (tried to) export just one schema, not entire database.
Anyway: if you got bunch of files, then it is because you instructed the tool to do so. Next time choose single file:
Is there some way to automatically export the query results in PL/SQL Developer? CSV or XLSX for example
PL/SQL Developer comment directives only take effect if you actually export the data. You still need to right-click on the header of the result grid, click Export Results, and then click either "CSV file" or "Excel file". Comment directives don't fully automate exports, but they at least save you a few clicks. See the PDF manual in Help --> User's Guide for more information about that feature.
How to export multiple tables in oracle into multiple .csv files in Oracle SQL developer
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.
Related Topics
How to Reset an MySQL Autoincrement Using a Max Value from Another Table
Sqlite Multi-Primary Key on a Table, One of Them Is Auto Increment
Truncate Multiple Tables in One MySQL Statement
How to See Generated SQL from a Linq Query
How to Restrict Null as Parameter to Stored Procedure SQL Server
What Should I Consider When Selecting a Data Type for My Primary Key
What Is "Structured" in Structured Query Language
Select Distinct Values from 1 Column
Fill Null Values with Last Non-Null Amount - Oracle SQL
Sane/Fast Method to Pass Variable Parameter Lists to SQLserver2008 Stored Procedure
Are There Any Free Tools to Generate 'Insert Into' Scripts in Ms SQL Server
Delphi - Prevent Against SQL Injection
Update with Case and in - Oracle
SQL Server 2008 Thousands Separator for a Column
SQL 2005 Split Comma Separated Column on Delimiter