闪回版本查询和闪回事务查询的使用方法

闪回版本查询和闪回事务查询一般结合起来一起使用：先用闪回版本查询查询出事务ID,在用闪回事务查询查询出UNDO_SQL.

具体方法如下：
alter database add supplemental log data;
alter database add supplemental log data (primary key) columns;

create table fb_test(id number);

insert into fb_test values(3);
insert into fb_test values(1);
insert into fb_test values(2);
select * from fb_test;
commit;

update fb_test set id=2  where id=3;
commit;
update fb_test set id=2  where id=1;
commit;

闪回版本查询：
select versions_startscn,versions_endscn,versions_xid,versions_operation,id  from fb_test versions between scn minvalue and maxvalue;

闪回事务查询：
select xid,start_scn,commit_scn,undo_sql,table_name,operation,logon_user from flashback_transaction_query where xid=hextoraw('0400040097020000');