Oracle PROCEDURE

Searching for Text in Oracle Stored Procedures

SELECT *

  FROM DBA_source

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

You can also use:
  • ALL_source
  • USER_source

SELECT *

  FROM DBA_source

 WHERE UPPER(text) LIKE '%MYTEXT%'

   AND owner = 'MYSCHEMA';

Bibliography