Is there any query to find all tables in oracle that contains a particular text?
similar to UNIX syntax grep -rls 'text'
I have used the query select * from user_source where text like '%text%'; to find the text in packages.
Asked
Active
Viewed 84 times
0
-
http://stackoverflow.com/questions/208493/search-all-fields-in-all-tables-for-a-specific-value-oracle – Dinup Kandel Jun 28 '13 at 06:59
-
`text`... you want to check for `text` value in column names or in data present in tables?? – pratik garg Jun 28 '13 at 08:24