-
Title
How to re-open or show previously ran SQL query statements after closing Toad for Oracle? -
Description
How do I retrieve previously ran SQL query statements after exiting Toad for Oracle?
-
Resolution
If your previous queries ran successfully (valid SQL query), it should be logged in the SQL Recall feature of Toad. Press F8 key (or go to View menu | SQL Recall) to reveal the SQL Recall window that should be docked in the left hand side of Toad. It should list all your successful/valid SQL runs.
However, if a query did not run successfully, it will not be logged in there. There is a setting to log all query runs no matter a valid query or not, but this might use up your SQL Recall list space fast though. The setting is under View Menu | Toad Options | Editor | Code Assist | under SQL Recall section | un-check “Save only valid statements”.
A third option is to perform a Save on your SQL queries in actual files that can serve as a backups and just in case your SQL Recall History accidentally gets lost due to a computer crash.