# PL SQL in Toad for data analyst

**URL:** <https://forums.toadworld.com/t/pl-sql-in-toad-for-data-analyst/6892>\
**Category:** Toad Data Point & Toad Intelligence Central\
**Created:** [September 29, 2011, 4:29pm UTC](https://forums.toadworld.com/t/pl-sql-in-toad-for-data-analyst/6892 "2011-09-29T16:29:21Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![ewheet2\_906](https://avatars.discourse-cdn.com/v4/letter/e/3bc359/32.png) [@ewheet2\_906](https://forums.toadworld.com/u/ewheet2_906)\
**Post date:** [September 29, 2011, 4:29pm UTC](https://forums.toadworld.com/t/pl-sql-in-toad-for-data-analyst/6892/1 "2011-09-29T16:29:21Z")

</div>

Is it possible to run PL-SQL in TDA and export it to a text file?

---

<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:** [September 29, 2011, 5:14pm UTC](https://forums.toadworld.com/t/pl-sql-in-toad-for-data-analyst/6892/2 "2011-09-29T17:14:10Z")

</div>

Awhile back you could execute an Oracle function that returned a ref cursor. We then displayed as grid data. I don’t know if this still works. If so you should be able to export the data. I have not tried with an anonymous block.

Debbie

---

<div class="post-metadata">

**Author:** ![ewheet2\_906](https://avatars.discourse-cdn.com/v4/letter/e/3bc359/32.png) [@ewheet2\_906](https://forums.toadworld.com/u/ewheet2_906)\
**Post date:** [September 30, 2011, 10:46am UTC](https://forums.toadworld.com/t/pl-sql-in-toad-for-data-analyst/6892/3 "2011-09-30T10:46:21Z")

</div>

Do you have any examples of this? I am a fuzzy on how to return the ref cursor.

---

<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:** [September 30, 2011, 6:21pm UTC](https://forums.toadworld.com/t/pl-sql-in-toad-for-data-analyst/6892/4 "2011-09-30T18:21:18Z")

</div>

I’m pretty sure there is lots of examples on the internet

Debbie
