[Query] Oracle procedure, function select

SELECT * FROM user_source
WHERE 1=1
AND NAME IN (
              SELECT DISTINCT OBJECT_NAME
              FROM user_objects
              WHERE OBJECT_TYPE = 'PROCEDURE'
            )
ORDER BY NAME, LINE ASC
;

 

 

select * from user_objects
where object_type = 'PROCEDURE'; 

 

select * from user_source
where NAME = CLT_MST_U'

 

object_type 종류
INDEX PARTITION
SEQUENCE
TABLE PARTITION
SCHEDULE
PROCEDURE
LOB
PACKAGE
PACKAGE BODY
PROGRAM
TRIGGER
VIEW
INDEX
TABLE
FUNCTION
SYNONYM
TYPE
JOB