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