CODE EXAMPLE FOR SQL

pl sql search in all packages

SELECT name, line, text
  FROM dba_source
 WHERE upper(text) like upper('%<<your_phrase>>%') escape ''