# Looking for a string in all tables

**URL:** <https://forums.toadworld.com/t/looking-for-a-string-in-all-tables/34881>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [January 20, 2016, 4:09pm UTC](https://forums.toadworld.com/t/looking-for-a-string-in-all-tables/34881 "2016-01-20T16:09:23Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![an1518](https://avatars.discourse-cdn.com/v4/letter/a/53a042/32.png) [@an1518](https://forums.toadworld.com/u/an1518)\
**Post date:** [January 20, 2016, 4:09pm UTC](https://forums.toadworld.com/t/looking-for-a-string-in-all-tables/34881/1 "2016-01-20T16:09:23Z")

</div>

Hello,

Does TOAD have a feature to find a string in fields in all tables in the DB. When doing object search it checks object names and source but I do not see option to check contents of tables.

Thank you,

Amir

---

<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:** [January 21, 2016, 12:04pm UTC](https://forums.toadworld.com/t/looking-for-a-string-in-all-tables/34881/2 "2016-01-21T12:04:27Z")

</div>

No, but if you do a google search you should be able to find a pl/sql block to do that.
