Scripts   Home

Date of change of the Oracle DDL of a user object

A snippet of SQL to find the change time of an Oracle object in the database.

-- Get the name, type, date of change of the DDL of a user object.

select OBJECT_NAME, OBJECT_TYPE, LAST_DDL_TIME from dba_objects where
owner not in ('SYS','SYSTEM');
------------------- cut here -----------------------------------