After exporting to Excel I always create a new sheet called "SQL" and I copy and paste the query into it and set the font to Courier New.
I would like there to be a tickbox in our Export dialog to do this with the ability to name the query sheet and the data sheet.
See attached for a screenshot of the SQL Developer Export dialog with this option for what I mean.
This is similar to this https://sourceforge.net/p/squirrel-sql/feature-requests/238/ request created in 2007 (!) but that has been forgotten in time.
The difference between the two requests is that I would like the SQL query as a separate sheet rather than as a table with the data.
Hello, please just keep in mind, that SQuirreL has a great feature, that it can export multiple ResultSets each into separate Excel Sheet both from GUI and or from SQuirreL's meta languague. So in case one want to save also SQL SELECTS (commands) into separate one sheet, there has to be solved how and where these SQLs will be saved in the output. If all commands one below another in one Sheet or each ResultSet data sheet will have its own another SQL sheet next to it. Or if SQL Command will be saved as Note or Comment... Who knows? Stepan
That is a fair point.
However, before getting bogged down in solving all use cases together, perhaps we should do the basic case of one resultset and move onto multiple sets afterwards as a separate piece of work.
The following was implemented and will be available in future snapshots and versions:
Excerpt from change log:
Using snapshot 20250527_2036.
This feature request was actually something I wanted to post today, but luckily JohnnyBoy already did!
Now I'm wondering which option enables the tab with the SQL statement used to generate the result set when exporting to XLSX. Could you please point out to me which settings apply to this feature request?
The following was implemented and will be available in future snapshots and versions, excerpt from change log:
Hello, Gerd,
I have tested this RFE and this works as I understood and expected. From my point of view this Ticket could be Closed as Implemented.
Just few notices:
1) I do not understand, why exporting of SQL command export is disabled for interactive Export. It could be useful as an evidence how the data were exported. Once there is such possibility, why not to allow checkbox even for interactive export.
2) When using interactive Export window, there is no right side scroll bar. And for example now (morning) I am working on my notebook and it was almost unable to fit window on display to be able to hit OK button at the very bottom of that window. Enabling scrolling bar would be nice. The same for Preferences windows. Should I create separate task for this on Git Issue tracker?
Thank You very much, Stepan
Last edit: Stepan RYBAR 2025-06-19
The following was implemented and will be available in future snapshots and versions:
Excerpt from change log:
Concerning the height of the export to file dialog the following was implemented and will be available in future snapshots and versions.
Excerpt from change log: