Executing SQL Statements
TOAD not only enables you to easily edit and create SQL and scripts containing SQL, but also to execute the SQL, review explain plans, and examine, edit, or change the result-set data.
The easiest way to execute SQL is with the Execute SQL button, the leftmost button on the middle toolbar. This executes the statement and returns the data when in full-view mode. Remember that F6 toggles between just the SQL Editor window and the results panel.
F9 executes all of the SQL statements in the SQL window, as does the Execute SQL All menu option, as in figure 3.34. Shift-F9 executes the SQL statement at the cursor, or the SQL statement that is highlighted.
Figure 3.34. Executing SQL statements.
Shift-F9 executes the current ... |
Get TOAD® Handbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
