# BLOB

**URL:** <https://forums.toadworld.com/t/blob/38284>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [September 1, 2016, 12:56am UTC](https://forums.toadworld.com/t/blob/38284 "2016-09-01T00:56:55Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Erhan\_Gdc](https://avatars.discourse-cdn.com/v4/letter/e/5fc32e/32.png) [@Erhan\_Gdc](https://forums.toadworld.com/u/Erhan_Gdc)\
**Post date:** [September 1, 2016, 12:56am UTC](https://forums.toadworld.com/t/blob/38284/1 "2016-09-01T00:56:55Z")

</div>

Hello,

I can export single blob data to outside via wizard. But I need to export multiple blobs.

How Can I export multiple blobs using TOAD?

Regards…

---

<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 1, 2016, 5:43am UTC](https://forums.toadworld.com/t/blob/38284/2 "2016-09-01T05:43:26Z")

</div>

Right click in the grid and choose “Single Column Export”.

If you have an older version of Toad, it’s called “Export BLOBs (long,raw)” instead.

---

<div class="post-metadata">

**Author:** ![Erhan\_Gdc](https://avatars.discourse-cdn.com/v4/letter/e/5fc32e/32.png) [@Erhan\_Gdc](https://forums.toadworld.com/u/Erhan_Gdc)\
**Post date:** [September 2, 2016, 12:21am UTC](https://forums.toadworld.com/t/blob/38284/3 "2016-09-02T00:21:34Z")

</div>

Thank your reply. Yes, That’s true. I can already do it for one row. But there are many rows to fetch data. So I have to do it for per row. it takes too long time. I don’t want to do it.

I want to get all data to a empty file. Is there any chance or option to do it on Toad ?

Thanks.

![row.png](https://global.discourse-cdn.com/quest/original/2X/1/191cd5256a0d8ba6668456d21663eb282cdcc5d4.png)

---

<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 2, 2016, 5:43am UTC](https://forums.toadworld.com/t/blob/38284/4 "2016-09-02T05:43:45Z")

</div>

Single column export is designed to do exactly what you are asking for - export the BLOB/CLOB value (any value, really) from a single column into one or multiple files (one per row). Did you try it?

![SCE.jpeg](https://global.discourse-cdn.com/quest/original/2X/d/dcda2604971056914c74168a32366e634e357a39.jpeg)