# Saving result set in connected table

**URL:** <https://forums.toadworld.com/t/saving-result-set-in-connected-table/34596>\
**Category:** Toad Data Point & Toad Intelligence Central\
**Created:** [November 30, 2015, 12:07pm UTC](https://forums.toadworld.com/t/saving-result-set-in-connected-table/34596 "2015-11-30T12:07:15Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![lance.christenson](https://avatars.discourse-cdn.com/v4/letter/l/8e8cbc/32.png) [@lance.christenson](https://forums.toadworld.com/u/lance.christenson)\
**Post date:** [November 30, 2015, 12:07pm UTC](https://forums.toadworld.com/t/saving-result-set-in-connected-table/34596/1 "2015-11-30T12:07:15Z")

</div>

Still learning Toad Data Point. Can someone verify that the IMPORT function is needed to store the results of a query in a table in the same connection the data is being pulled from, ?

In normal Oracle sql I would code “CREATE TABLE AS”, but I don’t see any choice in Toad Data Point query builder for that, and a right-click on the result grid after the query is run seems to only give option to save to local storage.

---

<div class="post-metadata">

**Author:** ![AlekseyBazhenov](https://avatars.discourse-cdn.com/v4/letter/a/71e660/32.png) [@AlekseyBazhenov](https://forums.toadworld.com/u/AlekseyBazhenov)\
**Post date:** [November 30, 2015, 2:50pm UTC](https://forums.toadworld.com/t/saving-result-set-in-connected-table/34596/2 "2015-11-30T14:50:19Z")

</div>

If you have a query you always can add CREATE TABLE AS and re-execute it from the SQL Editor.

Or you can use Export |Export Wizard from the right-click menu to export the result into new table/file/add to existing table – there are a lot of different options there.

Regards

Aleksey

---

<div class="post-metadata">

**Author:** ![lance.christenson](https://avatars.discourse-cdn.com/v4/letter/l/8e8cbc/32.png) [@lance.christenson](https://forums.toadworld.com/u/lance.christenson)\
**Post date:** [November 30, 2015, 3:11pm UTC](https://forums.toadworld.com/t/saving-result-set-in-connected-table/34596/3 "2015-11-30T15:11:14Z")

</div>

Ah, yes, thanks a lot. I only thought the Export was to a file. Now I see that also it can produce a table.

**From:** Aleksey Bazhenov [[mailto:bounce-AlekseyBazhenov@toadworld.com](mailto:bounce-AlekseyBazhenov@toadworld.com)]

**Sent:** Monday, November 30, 2015 2:52 PM

**To:** [toaddatapoint@toadworld.com](mailto:toaddatapoint@toadworld.com)

**Subject:** RE: [Toad Data Point - Discussion Forum] Saving result set in connected table

**[RE: Saving result set in connected table](http://www.toadworld.com/products/toad-data-point/f/36/p/26941/57538#57538)**

Reply by Aleksey Bazhenov

If you have a query you always can add CREATE TABLE AS and re-execute it from the SQL Editor.

Or you can use Export |Export Wizard from the right-click menu to export the result into new table/file/add to existing table – there are a lot of different options there.

Regards

Aleksey

To reply, please reply-all to this email.

[Stop receiving emails](http://www.toadworld.com/products/toad-data-point/f/36/t/26941?subscribe=false) on this subject.

Or [  
Unsubscribe from Toad Data Point - General](http://www.toadworld.com/products/toad-data-point/f/36?subscribe=false) notifications altogether.

Toad Data Point - Discussion Forum

[Flag](http://www.toadworld.com/products/toad-data-point/f/36/p/26941/57538?AbuseContentId=69ae2c5f-3b8b-4a63-854b-278c9c567a67&AbuseContentTypeId=f586769b-0822-468a-b7f3-a94d480ed9b0&AbuseFlag=true)  
this post as spam/abuse.