To spool my results to a file, do I have to add the spooling statements to my script and then run the script in SQL Plus from TDA’s editor? Is there an easier way to do this?
Really your best way is to execute your SQL scripts in the editor and if you want to retain the result sets, save as “Toad Editor File” (*.tef). This will save the script and the results and open up into TDA editor.
If you really want use Oracle’s spool you would need to execute using the “Execute in External Application” action. This will logon and execute in SQL*Plus or you can configure to use the Quest Script Runner that is bundled with TDA.