[Oracle] package member 조회

SELECT

    TYPE, NAME

    --, LINE

    --, TEXT

    , REGEXP_REPLACE(TEXT, 'FUNCTION|PROCEDURE|;|\s|\(.*', '') TEXT2

FROM

(

    SELECT TYPE, NAME, LINE, UPPER(TEXT) TEXT

    FROM USER_SOURCE

    WHERE TYPE = 'PACKAGE'

    AND (1=2

        OR TEXT LIKE '%FUNCTION%'

        OR TEXT LIKE '%PROCEDURE%'

    )

)

ORDER BY TYPE, NAME, LINE