To see different kind of versions
VERSIONS BETWEEN { SCN | TIMESTAMP } start AND end
or
VERSIONS PERIOD FOR user_valid_time [ BETWEEN TIMESTAMP start AND end ]
Using the scn
SELECT
versions_startscn,
versions_endscn,
versions_xid,
versions_operation,
name, value
FROM agap.employees
VERSIONS BETWEEN scn 10255608 and 10255642;
VERSIONS_STARTSCN VERSIONS_ENDSCN VERSIONS_XID V NAME VALUE
----------------- --------------- ---------------- - --------- ----------
10255636 0200110003030000 U Pedro 6
Maria 1
10255636 Pedro 4
using the TIMESTAMP
SELECT
versions_starttime,
versions_endtime,
versions_xid,
versions_operation,
name, value
FROM agap.employees
VERSIONS BETWEEN TIMESTAMP
TO_TIMESTAMP('2017-09-16:14:15:04', 'YYYY-MM-DD HH24:MI:SS')
and
TO_TIMESTAMP('2017-09-16:14:19:48', 'YYYY-MM-DD HH24:MI:SS');
note: You can use VERSIONS_XID with Oracle Flashback Transaction Query to locate this transaction's metadata, including the SQL required to undo the row change and the user responsible for the change
