閃回事務查詢（基礎例項講解）

例項：
1、
查詢表t中的資料
SQL> select * from t;
        ID
----------
         1

2、
修改表中的一行資料
SQL> insert into t values(10);
1 row insertd.
SQL> commit;
Commit complete.
3、
SQL> select * from t;

        ID
----------
         1
        10
4、
閃回事物查詢
select xid,operation,commit_scn,undo_sql from flashback_transaction_query where xid in (
select versions_xid from t versions between scn minvalue and maxvalue);
XID              OPERATION                        COMMIT_SCN UNDO_SQL
---------------- -------------------------------- ---------- --------------------------------------------------
0A00130035010000 INSERT                               701803 delete from "HR"."T" where ROWID = 'AAAM6DAAEAAAAG
                                                             uAAC';

0A00130035010000 BEGIN                                701803