CODE EXAMPLE FOR SQL

sql developer search all packages for text

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