I'm using TOAD for Oracle and it has a interface that allows me to indicate a speadsheet, an instance(tab) name and a few other items to export the results of a query directly to excel.
I have a few SQL statements that I wish to run from PL/SQL and have them automatically exported to an Excel file with a given filename and tab name.
I will then schedule this procedure to run using TOAD scheduler.
At least I think that's the most straightforward way to schedule a query to run with the results exported to an excel file.
Anyone have any ideas on how do export the results from a query to a specific excel file/tab from PL/SQL?