To check all recent DDL modifications

To check all recent DDL modifications

select owner, object_type, object_Name, Timestamp Last_DDL from DBA_OBJECTS where  sysDate - TO_DATE(TimeStamp,'YYYY-MM-DD:HH24:MI:SS') < 1 order by Owner, Object_Name;