Formatting Multiple Table Data as INSERT Statements

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 that this window allows you to choose more than one object.

Figure 8.9. Export Table selection options.

Figure 8.10. Export Table Output options.

Figure 8.11 shows what this data looks like formatted in Notepad.

Figure 8.11. Multitable INSERT-formatted data in Notepad.