Scripts That Write Scripts

TOAD supports just about any kind of script. What makes Oracle so powerful is the ability to create scripts that actually build scripts!

Make sure to run any SQL*Plus script as a script!

The most basic SQL-creating-SQL is the DROP TABLE script. This script can be used to clean up a schema from a departing employee, for example. Figure 3.47 illustrates this simple script. Notice the SPOOL command. The output from this command appears in the Notepad window.

Figure 3.47. DROP TABLE SQL-Creating-SQL script.

TOAD can ...

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.