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