Search the text in DB schema

desc dba_source

select * from dba_source where upper(text) like '%ENTER THE TEXT YOU WANT TO SEARCH HERE%'