Tuesday, May 13, 2014

Find LAST UPDATED DDL in a TABLE

Find LAST UPDATED DDL in a TABLE

select object_name,object_type,
          to_char(created,’DD-MM-YY HH24:MI:SS’) created,
          to_char(last_ddl_time,’DD-MM-YY HH24:MI:SS’) last_ddl 
    from user_objects 
    where object_name=’ABC’;






No comments:

Post a Comment