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');