Saturday, March 25, 2017

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;



No comments:

Post a Comment