Hello,
We have atleast 1000 custom tables. From all the tables, i would like to search for a string '/mycomp'. Is it possible to build a query for this?
I recently build the below query to search from the packages but not from the tables. Below is the query i used for packages but i am unable to figure out to search in all my custom tables.
select * from dba_source where upper(text) like '%//mycomp%' escape '/'
Thanks
KK