Few ways to peek into your DB's history

SELECT salary FROM emp AS OF TIMESTAMP TIMESTAMP '2021-12-31 23:59:59.999999999' WHERE  id = 1111

SELECT deptno, dname, VERSIONS_STARTTIME, VERSIONS_XID, VERSIONS_OPERATION 
FROM dept VERSIONS BETWEEN TIMESTAMP SYSTIMESTAMP - INTERVAL '20:00' MINUTE TO SECOND AND SYSTIMESTAMP 
WHERE deptno = 10;

SELECT * FROM table_a WHERE ora_rowscn >= timestamp_to_scn(trunc(sysdate));

It depends how the DBA has configured the database. History is tracked by a number - SCN which is basically a rollback entry automatically created whenever you do any DML.

Detailed explanation on how this all works: Time travel with SQL!

What is SCN?

---

Misc info

• stackoverflow / Timestamp to SCN
• stackoverflow / ORA_SCN can change on it's own