I am using oracle database and trying to search data in whole database. I know that value 'test' is stored in some tables but i dont know in which table,table column contain that value. So I want to write a query to search the whole database to find out the which table contains that 'test' string. any simplest solution. thanks
Asked
Active
Viewed 209 times
1
-
Can you please rewrite your question, it really makes no sense. – Matthew Watson Aug 23 '11 at 14:02
-
1i dont know exactly which table contains the data. and i want to find out that. – naren Aug 23 '11 at 14:49
-
Where's the link to the original? – zundarz Feb 10 '17 at 15:17
-
http://stackoverflow.com/questions/208493/search-all-fields-in-all-tables-for-a-specific-value-oracle/5114486#5114486 – zundarz Feb 10 '17 at 15:32
-
http://www.mikerodey.com/oracle-pl-sql-search-string-all-tables – zundarz Feb 10 '17 at 15:35