Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to search all the tables for some information

Kum KMar 18 2016 — edited Mar 22 2016

Hello,

We have atleast 1000 custom tables. From all the tables, i would like to search for a string '/mycomp'. Is it possible to build a query for this?

I recently build the below query to search from the packages but not from the tables. Below is the query i used for packages but i am unable to figure out to search in all my custom tables.

select * from dba_source where upper(text) like '%//mycomp%' escape '/'

Thanks

KK

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 19 2016
Added on Mar 18 2016
11 comments
1,831 views