O'Reilly logo

Oracle® Database 10g Insider Solutions by Richard Stroupe, John Kanagaraj, Arun Kumar R.

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required