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!

sql query for finding a string in a column of a table

Mac_Freak_RahulMar 5 2012 — edited Mar 5 2012

Hi All,

I have an issue, I have gotten a string ie '1D USD PRIME' and I have access to oracle's dictionary tables and views such as (all_source, all_tab_cols etc), my requirement is to find which table' column holds my above mentioned string, so I mean both the table name and the column name, it could be that this string might exist in more than 1 table so I want all the tables that holds it.

Regards
Rahul

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 2 2012

Added on Mar 5 2012

6 comments

173 views