1. Highlight the statement.

  2. Select the Editor|Add to Named SQLs menu item.

  3. Type a name for this SQL statement, one that you can easily recall at a later time.

  4. Named SQL is case sensitive: you can store both "sql1" and "SQL1".

  5. Drag SQL from the SQL window into the Editor and drop it where you want it.

  6. Right-click over SQL in the SQL Recall window and select Edit to change it.

  7. Use Toad Options|Editor|Code Assist|SQL Recall - Statements to save to limit the number of SQL statements Toad stores.