Thursday, July 17, 2014

CHECK USER OBJECTS LAST UPDATED TIME


SELECT owner || '.' || object_name object_name, object_type, to_char(last_ddl_time,'MM-DD-YYYY HH24:MI:SS') last_ddl_time FROM dba_objects  WHERE  owner in ('UKIRAN') ORDER BY owner, object_type;


 

No comments:

Post a Comment