Procedure, Function 등에서 필드나 특정단어 검색

SELECT OBJECT_NAME, OBJECT_TYPE, TEXT
  FROM USER_OBJECTS A, USER_SOURCE B
 WHERE     OBJECT_TYPE IN
              ('TRIGGER',
               'PROCEDURES',
               'FUNCTION',
               'PACKAGE',
               'PACKAGE BODY',
               'PROCEDURE',
               'VIEW')
       AND A.OBJECT_NAME = B.NAME
       AND UPPER (B.TEXT) LIKE '%검색어%'