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…

Oracle – Auto Generate Insert Statement with Toad

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

Oracle – Auto Generate Insert Statement with Toad

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

Oracle – Auto Generate Insert Statement with Toad

• Required Out file is ready with Insert statement as

Oracle – Auto Generate Insert Statement with Toad

If you have any comment/suggestion please share.