Need a script for quiqly find specific value in all columns of table. Something like this dont work:
select column name from table where value = 'value'
Asked
Active
Viewed 668 times
0
-
There's no trivial answer to this question. See [this question](http://stackoverflow.com/questions/208493/search-all-fields-in-all-tables-for-a-specific-value-oracle) that covers the same topic. – xlecoustillier Jul 12 '13 at 09:52
-
possible duplicate of [Search value in all tables of database Oracle 10](http://stackoverflow.com/questions/17591007/search-value-in-all-tables-of-database-oracle-10) – Alex Poole Jul 12 '13 at 10:43