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 -----------------------------------

The views and opinions expressed in this page are strictly those of the page author.
The contents of this page have not been reviewed or approved by the University of Minnesota.