How do I to get a Script Output (flat file text) in Toad for Data Analysts?
Unlike Toad for Oracle, Toad for Data Analysts does not have this ability to do this internally.
Toad for Data Analysts needs to rely on an outside app, such as Quest ScriptRunner.
This can be invoked by Editor | Execute SQL Script in External app.
1. Enter SQL into Editor
2. From the main menu, select Editor | Execute SQL Script in External App menu option. This option will open Toad Quest Script Runner application. It will open QSR in a separate window and will run all queries and place all results in the single bottom pane.
3. Right click inside this pane and save the output to a file.
Other External Apps may be sustituted for Quest ScriptRunner.
One can configure ather external apps (i.e. SQL*Plus) in the Tools | Options | Database | Oracle | External Option