Flashback Versions Query
The flashback versions query is another new feature introduced with the 10g Database that will allow you to retrieve a history of changes for a specified set of rows within a table. This new feature expands the flashback query technology first introduced in Oracle 9i. Instead of specifying a time or SCN to enable flashback query for analysis, you can now use the VERSIONS_BETWEEN clause to retrieve all the versions of a specified set of rows that exist or ever existed between the time the query was issued and a point back in time that you must specify. The VERSIONS_BETWEEN clause eliminates the need to flashback in time to review historical row modifications over time.
The flashback versions query feature, like Flashback ...
Get Oracle® Database 10g Insider Solutions now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
