ORACLE 프로시저 검색 QUERY문

 

SELECT *
    FROM USER_OBJECT
    WHERE OBJECT_TYPE = 'PROCEDURE';

SELECT DISTINCT(name)
   FROM USER_SOURCE
 WHERE TYPE = 'PROCEDURE';

 

* 특정 프로시저 내용 검색

SELECT TEXT
     FROM USER_SOURCE
     WHERE NAME = UPPER('PROCEDURE_NAME');