Check procedure created or replaced last time in oracle Database

Check procedure created or replaced last time in oracle Database

 

Procedure created or replaced date - 

col owner for a30

col object_name for a30

set linesize 190

SELECT DISTINCT OWNER, OBJECT_NAME, CREATED, LAST_DDL_TIME FROM ALL_OBJECTS WHERE OBJECT_TYPE = 'PROCEDURE' and object_name=UPPER('&procedure_name');

Get procedure new defination - 

set linesize 190

set page 800

spool file.txt

SELECT TEXT

FROM ALL_SOURCE

WHERE OWNER = '&owner_name'

AND NAME = '&procedure_name'

ORDER BY LINE;

spool off