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 scripts should be checked as Quick Scripts as shown in Figure 9.66. This results in the main menu toolbar for the Script Manager having drop-down lists for all those categories containing quick scripts and their scripts as shown in Figure 9.67. Choosing a Quick Script from the main menu toolbar results in that script being loaded into the TOAD SQL Editor and executed as a script.

Figure 9.67. TOAD Script Manager ”Quick Scripts.

Second, you can include one or more scripts from the Script Manager window and execute them as one concatenated script as shown in Figures 9.68 and 9.69. If you check the Include box for scripts USERS.SQL and WHO.SQL and then click the Execute toolbar icon, these two scripts are run as one in the TOAD SQL Editor.

Figure 9.68. TOAD Script Manager ”Include Scripts.

Figure 9.69. TOAD Script Manager ”Execute Includes.

And third, you can create new SQL scripts from the combinations of existing SQL scripts as shown in Figure 9.70 by clicking the Combine button. Thus you can incrementally build upon all your collections of scripts.

Figure 9.70. TOAD Script Manager ”Combine Scripts.



TOAD Handbook
TOAD Handbook (2nd Edition)
ISBN: 0321649109
EAN: 2147483647
Year: 2003
Pages: 171

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net