Searching for PL/SQL code for a string or key


SELECT type, name, line
  FROM   user_source
WHERE  LOWER(text) LIKE LOWER('%&KEYWORD%')

You can view this article online at:
http://www.kiranreddys.com/knowledgebase/index.php/article/searching-for-plsql-code-for-a-string-or-key