利用flashback_transaction_query表撤销已提交的修改

select versions_xid, versions_operation
  from test versions between scn minvalue and maxvalue;   --SCN

select versions_starttime,
       versions_endtime,
       versions_xid,
       versions_operation
  from test versions between timestamp minvalue and maxvalue;  --Timestamp

select *
  from flashback_transaction_query
 where xid = hextoraw('06000700F3030000');  --Undo SQL