TOAD® Handbook

Formatting Data as INSERT Statements

TOAD allows you to export data from the Schema Browser into INSERT statements. Right-clicking on the table in the Tables tab of the Schema Browser brings up the list of menu items illustrated in Figure 8.4. Select Export Data and you get the Data Export window shown in Figure 8.5. The Columns tab of the Data Export window allows you to select the columns you want.

Figure 8.4. Exporting data in the Schema Browser.

Figure 8.5. The Columns tab of the Data Export window.

Creating a script with INSERT statements ...