트리거, 프로시져등에서 특정 문자열 찾기

select

    distinct name

    ,type

    ,line

    ,TRIM(text)

    ,COUNT(*) OVER(PARTITION BY TYPE) AS CNT

from ALL_SOURCE

where owner='MAXIMO'

and upper(TEXT) like '%50000004%'

and type IN ('PROCEDURE', 'TRIGGER','PACKAGE','FUNCTION','PACKAGE BODY')

order by type,name