2 from transaction_table
3 versions between timestampminvalue and maxvalue
4 order by versions_xid;
TID TNAME V VERSIONS_STARTTIME VERSIONS_ENDTIME VERSIONS_XID
2 Mary123 U 21-9月 -11 11.13.24 上午 0400140020040000
3 Mike D 21-9月 -11 11.13.24 上午 0400140020040000
2 Mary I 21-9月 -11 11.12.39 上午 21-9月 -11 11.13.24 上午 0700250012040000
1 Tom I 21-9月 -11 11.12.39 上午 0700250012040000
3 Mike I 21-9月 -11 11.12.39 上午 21-9月 -11 11.13.24 上午 0700250012040000
SQL> -- 执行闪回事务查询
SQL> select operation,undo_sql
2 fromFlashback_transaction_query
3 where xid='0400140020040000';
OPERATION
--------------------------------
UNDO_SQL
------------------------------------------------------------------------------------------------------------------------------------------------------
DELETE
insert into"SCOTT"."TRANSACTION_TABLE"("TID","TNAME")values ('3','Mike');
UPDATE
update"SCOTT"."TRANSACTION_TABLE" set "TNAME" = 'Mary'where ROWID = 'AAANiBAAEAAAAG3AAB';
BEGIN
SQL> update"SCOTT"."TRANSACTION_TABLE" set "TNAME" = 'Mary'