Oracle – Auto Generate Insert Statement with Toad

This is very quick way to generate the Insert Statement for all of the data in your table.

Let us take an example; we have a table as shown below…

• Right click on the Result Grid and go to Option à Export Dataset

• Select the Export Format as “Insert Statement”
• Select the Output file location and name
• You can also change the Schema (if required)

• Required Out file is ready with Insert statement as

If you have any comment/suggestion please share.