What is the Flashback Query?
A database query, by default, always shows a consistent set of data containing most recently committed changes. With the introduction of the Flashback Query in Oracle9i,users will be able to query a consistent version of the database as it was at some point in the past either by specifying a wall clock time or a System Change Number (SCN).
