Database Reference
In-Depth Information
Figure 13.11
A Flashback
Versions Query.
, TO_CHAR(VERSIONS_STARTTIME, 'HH24:MI:SS') "STime"
, TO_CHAR(VERSIONS_ENDTIME, 'HH24:MI:SS') "ETime"
, VERSIONS_STARTSCN "SSCN"
, VERSIONS_ENDSCN "ESCN"
, VERSIONS_OPERATION
, DECODE(VERSIONS_OPERATION,'I','Insert','U'
,'Update','D','Delete','Error') "DML"
FROM CONTINENT VERSIONS BETWEEN TIMESTAMP
MINVALUE AND MAXVALUE
ORDER BY CONTINENT_ID;
Oracle Database 10
g
now allows both FLASHBACK DATABASE
and FLASHBACK TABLE operations, as in the following syntax:
FLASHBACK [ STANDBY ] DATABASE [ database ]
TO { SCN | TIMESTAMP } expression;
FLASHBACK TABLE { [ schema.]table , ... }
TO { SCN | TIMESTAMP } expression
