title: How to batch export only 10 rows from Oracle SQL developer query results for each table to separate excel files
body: <p>I have 50 tables on a schema on Oracle server. Each table has roughly 1 million rows. I want to export all tables to separate excel files. I only need 10 rows for each table. I know I can select 10 rows and manually export it to excel file one by one. Is there any way to set exporting only 10 rows in Export Wizard, and export 50 tables to separate excel files in batch (automatically)? Thanks.</p>