There are several ways for your reference.

1, for the commit (the last operation commit) then you can query that commit segment SELECT

Column name 1, column name 2 ......FROM table name VERSIONS BETWEEN TIMESTAMP MINVALUE AND MAXVALUE where VERSIONS_STARTTIME IS NOT null ORDER BY VERSIONS_STARTTIME DESC;Check out the first is the last change in the data

2, if there is a sequence inside the table or a fixed sort field can be inverted by the order of the first where rownum<2 order by sort field desc

3, there is another way is to use ORACLE pseudo-column rowid

select * from tbl t1 where t1.rowid=(select max(rowid) from tbl t2)

4, in redo log to find the corresponding related table insert statement, but so find the sql statement, not the data. You have to use the log miner tool to check the redo log.

This is a few common methods, I hope my answer can help you.

Oracle Database, also known as Oracle RDBMS, or simply Oracle, is a relational database management system from Oracle.