I have the sql - thanks.

select name, line,type, text from dba_source
where text like '%text....%'