Validate Syntax

Prior to executing SQL statements you can:

Check SQL syntax (checks whether the syntax is valid without executing)
Verify SQL (checks whether the syntax is valid, executes the code, and then undoes any changes to the code object and data)

To check SQL syntax

Select the block of code in the Editor, and click

To verify SQL

Select the block of code in the Editor, and click

Caution When possible, Toad undoes any changes to the object and data in the database after executing the script (notice that the Result Sets tab is empty). However, Verify SQL cannot rollback statements that use implicit commits, such as CREATE table and DROP database. For those statements, the object remains/is removed from the database when you verify the SQL statement.

Note: The script is automatically checked for syntax errors when opening a script, executing current statement (F9), checking syntax, changing database or refreshing the Script Map. The syntax errors are listed in the Script Results pane in the Messages tab.