More to the point Oracle has flashback queries: SELECT ... AS OF <timestamp or logical clock time> So you can query the database as of any point in the pa

More to the point Oracle has flashback queries: SELECT ... AS OF <timestamp or logical clock time> So you can query the database as of any point in the past, making manual work to implement the same feature with custom columns redundant. Oracle can also show you a record of transactions made and what SQL to run to undo them, including dependency tracking between transactions.