SQL Templates
TOAD can easily format a SELECT or INSERT statement for any data-oriented object (view or table). Simply place the cursor on the object you want and press F4. This will perform a describe on the object, as illustrated in Figure 4.23.
Figure 4.23. Object description.
Notice in Figure 4.23 that everything you need to know about the object appears in this window.
 | It is particularly nice to have TOAD build a script that created the object. This information comes from the data dictionary and accurately reflects the object that you ... |
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.
