This is my first post here and I have a question about queries export.
I have multiple .sql files (+600) and each return between 100k - 300k lines.
I need to export the results from each .sql to .xlsx files.
What I’m doing now, F9, right click “export dataset”, type the name of the file (that should be the same as the .sql file) and export to Excel file but it’s exhaustive.
I tried list iterator + export dataset but in the tab Dataset I put %List Iterator1% as I saw in this same forum and I have “invalid SQL statement”.
Is there any way to automatize this work or simplify it? My knowledge in Toad is almost zero, please, any help would be great. Thank you