CODE EXAMPLE FOR SQL

oracle last modification in table

SELECT INSERTS, UPDATES, DELETES, TRUNCATED, TIMESTAMP
FROM DBA_TAB_MODIFICATIONS
WHERE TABLE_NAME = 'my_table'
  AND TABLE_OWNER = 'my_owner';