Building SQL and PL/SQL Using TOAD
TOAD enables you to create and modify SQL and PL/SQL. This code can be entered in a blank SQL Edit window, load SQL in from a file (menu bar File, Open File, see Figure 16.8), recall a previously edited SQL statement, or be recalled from a previously created work session. A SQL edit window can also be launched from the object browser, the schema browser, or the SGA trace window.
Figure 16.8. TOAD supported file types.
Working with SQL
TOAD allows you to view available columns while working on a SQL query.
1. |
After you type the table name (or view name) and the period, press CTRL+T or wait a few seconds.
|
2. ... |
Get Oracle9i™ Development by Example 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.
