Flashback Versions Query Walkthrough

SQL> create table digits (id number(2), description varchar(20));

Table created.

SQL> insert into digits values (1, 'ONE');

1 row created.

SQL> update digits set description = 'TWO' where id=1;

1 row updated.

SQL> insert into digits values (2, 'TWO');

1 row created.

SQL> commit;

Commit complete.

SQL> delete from digits;

2 rows deleted.

SQL> select description from digits versions between timestamp minvalue and maxvalue;

DESCRIPTION
--------------------
TWO
TWO