SQL Recall
Toad saves all the work that was done in any of the editor windows.
ALT+Up Arrow and Alt+Down Arrow walk through this storage area. Choose View → SQL Recall or press F8 (see Figure 3.26) to open the interface shown in Figure 3.27.
FIGURE 3.26 Accessing SQL Recall
FIGURE 3.27 SQL Recall panel
Notice that the SQL Recall panel shows up as an autohide panel on the left side of Toad.
You simply double-click a SQL statement in this panel and Toad will open a new tab and put the SQL in it.
This version of Toad enables the SQL to be moved to the Personal tab or the Named tab. Simply click the Edit Selection button in the SQL Recall window, and then select the Personal or Named option from the Type drop-down menu.
The buttons on the top of this panel (see Figure 3.28) enable you to do the following:
- Save selected SQL to a file
- Copy selected SQL to the clipboard
- Edit the selected SQL (allows for the SQL to be added to the Personal or Named tabs, which makes finding SQL easier, perhaps)
- Delete from the SQL Recall
- Load into the SQL Editor (Append, New Tab, or Replace into current tab)
- Navigation buttons
- Export/Import all the SQL (useful when updating Toad or moving to a new computer)
FIGURE 3.28 SQL Recall panel buttons
The Configure Toad Option → Editor → Code Assist SQL Recall settings (see Figure 3.29) control how many SQL statements are saved (max is virtually unlimited) and which SQL will be saved (all, or just valid ones). The Save Only Valid Statements option saves only the successful SQL, enabling more SQL to be saved. Typically, programmers are only interested in the SQL statements that didn’t have syntax errors.
FIGURE 3.29 SQL Recall options