Knowledge Hub — Technical Document

Generated on 2026-08-28 06:59 | Confidential Client Asset

Flashback Queries

Published July 26, 2025 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