How do I export query results direct to CSV format in Toad for Oracle?
To do it repeatedly use Automation Designer:
1) Create a new app and add the action Export Set
2) Open properties of the Export Set and set the output format to Delimited and configure output as needed.
3) Use the SQL query as a source.
4) Use the Scheduler Wizard to set the schedule.
Please be aware, that the computer must be on in time of the schedule.
To do it once:
1. In the Save Grid Contents window, select Delimited Text as the Export format.
2. Ensure the Comma is selected as the Delimiter character.
3. For the File output name, change the extension from txt to csv.
4. Click OK to export and the export will save a CSV file.
