Knowledge Hub — Technical Document

Generated on 2026-10-13 05:04 | Confidential Client Asset

Flashback Queries

Published October 02, 2026 By Sai Sree Ram Gundepudi

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.

Was this solution helpful?

Your feedback helps improve our technical knowledge repository.

Share this article