Exporting 120 tables one by one via manual query results export is such a tedious task—let’s cut down that time drastically with these practical, efficient methods tailored for PL/SQL Developer:

Method 1: Use PL/SQL Developer’s Built-in Batch Table Export Tool #

This is the simplest and most straightforward approach, since it’s built right into the tool and requires no scripting:

• Right-click on your database connection in PL/SQL Developer’s Object Browser, then select Export Tables.
• In the "Tables" tab of the export window, use the checkboxes to select all 120 tables you need (you can use Ctrl+A to select all, or filter tables by name using the search bar if needed).
• Switch to the Output tab:
  • Set the output type to File, then choose the format as Excel (.xlsx).
  • Enable the One file per table option—this ensures each table gets saved as its own separate .xlsx file.
  • Pick a target folder for your exports, and tweak other settings (like including column headers, date formats, or trimming whitespace) to match your needs.
• Click Export and let PL/SQL Developer handle the rest. This method will process all tables in one go, saving you hours of repetitive clicks.

Method 2: Automate via Command Line Script #

If you need more flexibility or want to schedule exports later, you can use PL/SQL Developer’s command-line interface to generate batch commands:

1. First, run this query in the SQL Window to generate export commands for each target table:

SELECT 'plsqldev.exe your_username/your_password@your_database EXPORT TABLES=(' || table_name || ') FORMAT=xlsx FILE=C:\YourExportFolder\' || table_name || '.xlsx'
FROM user_tables
-- Add a WHERE clause here to filter only the tables you need, e.g.:
-- WHERE table_name LIKE 'YOUR_TABLE_PREFIX%'
ORDER BY table_name;

2. Copy all the generated commands from the query results.
3. Paste them into a new text file, save it with a .bat extension (e.g., ExportTables.bat).
4. Double-click the batch file to run it—PL/SQL Developer will launch in the background and export each table to its own .xlsx file automatically.

Key Notes for Both Methods #

• Make sure you have SELECT permissions on all target tables, and write access to the folder where you’re saving the exports.
• For large tables, consider adjusting PL/SQL Developer’s memory settings (under Tools > Preferences > Environment > Memory) to avoid performance issues.
• Test with 1-2 tables first to verify the output format matches your expectations before running the full batch.

内容的提问来源于stack exchange，提问作者Amber Rebecca Howe