Select from a table at a certain point in history. This can be useful if you have made a mistake and edited or deleted data. Be careful though, because you have to have flashback enabled, and also set with enough space to capture all the changes that you need to recover.
Any DDL on the table will reset the ability to flashback.
SELECT * FROM TABLE_NAME AS OF TIMESTAMP SYSDATE - time_unit;