How to generate Insert statements for all or selective columns of a table? (4304957)

How to generate Insert statements for all or selective columns of a table?

For Toad 10.X

RESOLUTION 1:

1. In the Schema Browser | Tables tab, right click and select 'Export Data'
2. In the Export Data window, select ‘Insert Statements’ from the ‘Export Format’ drop down
3. Choose your file output type

RESOLUTION 2:

1. In the Data Grid, right-click and select ‘Export Dataset’
2. In the Export Data window, select ‘Insert Statements’ from the ‘Export Format’ drop down
3. Choose your file output type

For Toad 8.X and 9.X

In the Schema Browser | Tables tab, right click and select "Export Data" which will generate Insert statements for all the data in that table. Or on the right-hand side Data tab, select "Create INSERT for selected Rows" to generate the statements for all or filtered data set (set by the Filter icon). Both options have a Columns tab which enables user to select specific columns to include in the Insert statements.