Managing SQL Scripts Made Easy

Over time, everybody doing Oracle work, DBAs and developers alike, collects tons of SQL scripts. Wouldn’t it be nice if TOAD could help you organize and execute your collections of SQL scripts? TOAD can with the Script Manager screen shown in Figure 9.66. TOAD ships with two useful categories of scripts predefined for you: DBA and Oracle 8i data dictionary. Of course, you can create additional categories. Likewise, you can add scripts to categories (even the predefined ones).

Figure 9.66. TOAD Script Manager.

But the real power of the Script Manager lies in three key capabilities. First, you can indicate which ...

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.