How can the Flashback Query feature be used?
The Flashback Query is essentially a self service tool which allows application users to correct their mistakes with minimal DBA intervention. Once the DBA configures the undo tablespaces with appropriate size and undo retention period, no further administrator intervention is required to query the database at a past point of time. However, in the initial release of Oracle9i, this feature is targeted more towards application developers than end users since its use currently requires some PL/SQL coding.