0

I'm looking for a keyword that could be in any tables and fields in Oracle. I tried to use the codes below but this only allow me to search a string in all stored procedures, functions and packages. My goal is to search inside the fields. Any help would be appreciated. Thank you.

SELECT *
 FROM all_source
 WHERE LOWER (text) LIKE LOWER ('keyword');
RJAP
  • 49
  • 6

0 Answers0