Is there a way to auto-save all of the SQL statements I run in Toad for Oracle in one file?
Toad for Oracle does not have the functionality to save several SQL statements in one file, but Toad does have the SQL Recall feature (press F8) that automatically saves all your valid SQL runs and keeps it in the SQL history. Please try this feature and see if that will work for you.
It is also recommended that you backup the file where your SQL history is stored (“SavedSQL.dat” file) just in case of i.e. a crash that corrupts the file. You can find this file in {C:\Documents and Settings\<YOUR_USER>\Application Data\Quest Software\Toad for Oracle\9.7 (or 10.x or 11.x)\User Files\}, and back up the “SavedSQL.dat” file.
