Flash Back Query:
-----------------------

You perform a Flashback Query using a SELECT statement with an AS OF clause. You use a Flashback Query to retrieve data as it existed at some time in the past. The query explicitly references a past time using a timestamp or SCN. It returns committed data that was current at that point in time.

SELECT COL1 COL2... FROM <TABLE_NAME> AS OF TO_DATE('05/01/2009' 'MM/DD/YYYY');