We love getting enhancement requests from our users. A good deal of the development in SQL Developer is guided by what our users are asking for.
It does pain me a bit though when someone asks for a feature what we already have.
We frequently have a requirement to export working data (especially for data modeling purposes) to spreadsheets. It would be helpful if SQL Developer export had an option to export all tables to individual spreadsheets, creating one spreadsheet per table. So exporting a schema of 50 tables would create 50 spreadsheets in a single export operation. The spreadsheet name should include the table name. Today the export function does not allow me to export more than one table at a time. For a large schema with many tables, the export schema function would be very handy. The new dialog should allow the user to select one or more tables to export (including an all tables option).
- export more than 1 table
- to Excel
- one file per table
- default to the table name
I read this as a spreadsheet = an Excel file. If you read it as a one or more worksheets in a single workbook (single Excel FILE), then skip to the bottom, because we support THAT too.
Tools > Database Export
You can ‘filter’ out the columns you don’t want to export for each table. Again, we default to grabbing everything. You can add WHERE clause filters for each table – and also preview what that data will look like.
There’s a global where input as well – that will add a ‘WHERE XYZ’ clause to every SELECT we use to grab the data. So if you want to only grab records that have an ID in (1,2,3,4,5) add THAT to your global where.
But Wait, What About Multiple Worksheets in a Single Workbook??
In other words, just one file, and a tab per table?
Yeah, it’ll do that too.