Toad World® Forums

Exporting results into Insert statements


#1

I was trying to query the results joining couple of tables. I wanted to save the results that appear in the lower browser under Grid1 as the insert statements.

Please guide how I can do it in TOAD.


#2

First, run your query with F9. It sounds like you ran it with F5.

Then right-click in the grid. If you have Toad 10 or newer, choose “Export
Dataset”. It was called “Save As” in older versions.


#3

My Toad version is 9.6. I tried with F9 too and tried Save as option.

In the dataset tab, I see the same select query which I used. I donot want the select query, I want the insert statement.

Please suggest.


#4

Try doing a right-click on the grid, not the editor. Then select “Export
As” and select “Insert Statements” from the combo box at the
top of the dialog box. . .


#5

Thanks, it worked :slight_smile: