# Exporting results into Insert statements

**URL:** <https://forums.toadworld.com/t/exporting-results-into-insert-statements/9867>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [September 23, 2010, 1:24pm UTC](https://forums.toadworld.com/t/exporting-results-into-insert-statements/9867 "2010-09-23T13:24:01Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\
**Post date:** [September 23, 2010, 1:24pm UTC](https://forums.toadworld.com/t/exporting-results-into-insert-statements/9867/1 "2010-09-23T13:24:01Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [September 23, 2010, 1:42pm UTC](https://forums.toadworld.com/t/exporting-results-into-insert-statements/9867/2 "2010-09-23T13:42:32Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\
**Post date:** [September 23, 2010, 1:54pm UTC](https://forums.toadworld.com/t/exporting-results-into-insert-statements/9867/3 "2010-09-23T13:54:54Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\
**Post date:** [September 23, 2010, 3:14pm UTC](https://forums.toadworld.com/t/exporting-results-into-insert-statements/9867/4 "2010-09-23T15:14:12Z")

</div>

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. . .

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\
**Post date:** [September 26, 2010, 8:50pm UTC](https://forums.toadworld.com/t/exporting-results-into-insert-statements/9867/5 "2010-09-26T20:50:09Z")

</div>

Thanks, it worked 🙂
