Toad World® Forums

Toad difference


#1

what the difference between SQL recall, toad views, and code snippets?


#2

SQL Recall stores a copy of the SQL you execute. This gives you easy access to find and locate a previous version of the SQL you are working with.

Toad Views take a SQL statement and encapsulate it so you can drag onto the Query Builder and treat it as a view without making a subquery. This view is not stored in the database but stored and handled in Toad.

Code Snippets are small sections of code that SQL Coders use often. IE: DATE_FORMAT function. If you drag that snippet into the editor it will include the function name and parameters and help you insert values. I like to user the Code Snippet docked window to learn or search for functions that I am not sure about. At the bottom on each there is often a link to the DB Venders help site.