# Spool SQL to File

**URL:** <https://forums.toadworld.com/t/spool-sql-to-file/5869>\
**Category:** Toad Data Point & Toad Intelligence Central\
**Created:** [June 13, 2008, 8:24am UTC](https://forums.toadworld.com/t/spool-sql-to-file/5869 "2008-06-13T08:24:29Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ben\_Boise](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/ben_boise/32/15_2.png) [@Ben\_Boise](https://forums.toadworld.com/u/Ben_Boise)\
**Post date:** [June 13, 2008, 8:24am UTC](https://forums.toadworld.com/t/spool-sql-to-file/5869/1 "2008-06-13T08:24:29Z")

</div>

To spool my results to a file, do I have to add the spooling statements to my script and then run the script in SQL Plus from TDA’s editor? Is there an easier way to do this?

---

<div class="post-metadata">

**Author:** ![Debbie\_Peabody](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/debbie_peabody/32/18_2.png) [@Debbie\_Peabody](https://forums.toadworld.com/u/Debbie_Peabody)\
**Post date:** [June 13, 2008, 12:11pm UTC](https://forums.toadworld.com/t/spool-sql-to-file/5869/2 "2008-06-13T12:11:22Z")

</div>

Really your best way is to execute your SQL scripts in the editor and if you want to retain the result sets, save as “Toad Editor File” (\*.tef). This will save the script and the results and open up into TDA editor.

If you really want use Oracle’s spool you would need to execute using the “Execute in External Application” action. This will logon and execute in SQL\*Plus or you can configure to use the Quest Script Runner that is bundled with TDA.

Debbie
