Flashback Query

Retrieve historical data using AS OF TIMESTAMP.

SELECT * FROM employees AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '10' MINUTE)
WHERE employee_id = 101;

Requires undo data to be available.