will work. That will have to do a full scan on the table, though, so it's not going to be efficient.
SELECT scn_to_timestamp( max( ora_rowscn )) FROM table_name
ragu.dba.in wrote:That does not identify the DML statement correct? It gives the last modified row.
SQL>select scn_to_timestamp(max(ora_rowscn)) from