SQL Statement Recall
Toad The SQL Statement Recall window is dockable, and can be pinned or hidden.
Every statement executed in the SQL Editor is added to the statement recall list. This list is organized with the most recent SQL at the top. You can select a statement from this list and run it, you can remove a statement from this list, and you can name your statements for easy recall. In addition, you can classify a SQL statement as either a Personal SQL or Named SQL.
All statements (to a maximum set in Options|SQL Editor|SQL Recall) are saved between sessions of Toad, in the file Toad for Oracle\User Files\SAVEDSQL.xml.
The SQL Recall window displays the following information:
-
Name of SQL (if any)
-
SQL statement
-
Connection information
-
Date and time of last connection
Saving only valid SQL statements
You can save only those SQL statements that executed successfully. This saves the list from containing misspelled column names, SQL clauses, etc.
To set Toad to only save valid SQLs
-
In the View|Options|SQL Edit tab, select the Save Only Statements that are Valid check box.
Editing Saved SQL Attributes
You can edit Saved SQL statement attributes like Name, Type, and SQL within the SQL Recall grid.
To edit saved SQL attributes
-
Double-click the appropriate cell of the selected SQL statement.
-
Make any changes.
-
Click outside the selected cell, or press <Enter>.
(0) 
(0)
