SELECT *

  FROM DBA_source

 WHERE UPPER(text) LIKE '%MYTEXT%';

SELECT *

  FROM DBA_source

 WHERE UPPER(text) LIKE '%MYTEXT%'

   AND owner = 'MYSCHEMA';