Oracle DB SQL search string/text in all objects function/procedure/package/trigger

If you need to search for a string in all objects (functions/procedures/packages/triggers) of your schema you should run one of the following querys:

select  * from all_source where lower(text) like '%<desired_text>%'; - this will search in all schemas of your database

select * from user_source where lower(text) like  '%<desired_text>%'; -this will search only in the schema that you set when you run the query