Database Reference
In-Depth Information
Figure 13.10
An AS OF
Flashback Query.
Now let's update an existing row, not the one we previously inserted, so
that we can execute a flashback versions query.
UPDATE CONTINENT SET NAME = 'Australia and New Zealand'
WHERE NAME = 'Australasia';
Now we execute a flashback versions query. Figure 13.11 shows two ver-
sions of rows for Australasia plus Australia and New Zealand.
SELECT * FROM CONTINENT
VERSIONS BETWEEN TIMESTAMP MINVALUE AND MAXVALUE;
The following script, as shown in Figure 13.12, simply adds in all of the
versions flashback query pseudocolumns.
COLUMN ID FORMAT 990
COLUMN CONTINENT A16
COLUMN STIME FORMAT A5
COLUMN ETIME FORMAT A5
COLUMN DML FORMAT A6
SELECT CONTINENT_ID "ID", NAME "CONTINENT"
