select
(select to_char(last_ddl_time,'DD-MM-YYYY HH24:MI:SS') from dba_objects where object_name='Table_name' and owner='owner') "DDL Time",
decode(maxscn,0,'N/A',scn_to_timestamp(maxscn)) "DML Time"
from
(select nvl(max(ora_rowscn),0) maxscn from owner.table_name);
No comments:
Post a Comment