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!

Need a Query to search a value from all tables.

311152Jun 12 2012 — edited Nov 2 2012

Hi,

I would like to know, is there any way that we could search a string from all the tables.

For example I need to find a STRING 'hello world', on which table it presents. I want to search it from all the tables, as there might be a situtation
where we dont knwo which table the value gets stored.

REgards
Suresh

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 30 2012

Added on Jun 12 2012

#sql

9 comments

40,772 views