Formatting Multiple Table Data as INSERT Statements

TOAD allows you to export many kinds of things from the Database, Export menu, as illustrated in Figure 8.8. When you choose the Table Data submenu, the Data Export window displays. Notice that TOAD can easily create scripts for the various Oracle objects. This section will limit itself to the options that are available from the Data Export window.

Figure 8.8. Database Export menu options.

Figures 8.9 and 8.10 show the Tables and Options tabs of the Data Export window, which allow you to make choices for controlling the output. These options are much like those in the Schema Browser except ...

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.