Why and How to search all your code text in Oracle DB codes ?

Why ?

In Oracle to search in all codes source text (any code written like package body , function ..etc) if you need to search for certain word or any text matched it will difficult to open each one to see whether it contain this text or not , thus; you need to run the below query to reach this .

How ?

Below are commands in sql to reach this:

select *

from dba_source

where upper(text) like upper('%SOMETEXT%');