-- 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');
Wednesday, March 25, 2015
find the LAST_DDL_TIME change time of an Oracle object
SQL to find the LAST_DDL_TIME change time of an Oracle object in the 
database.
Subscribe to:
Post Comments
                                      (
                                      Atom
                                      )
                                    
 
No comments :
Post a Comment