1. 闪回版本查询:
1.1 查询时间定点数据库集合
select * from table as of timestamp to_date('2010-01-02 12:12:22','yyyy-mm-dd hh24-mi-ss');
1.2 查询表操作 版本查询
select versions_starttime vst_time,versions_startscn vst_scn,versions_endtime vend_time,versions_endscn vend_scn,versions_xid vxid,
versions_operation vop,id,name
from tbl_program versions between scn minvalue and maxvalue where versions_operation='U'
1.3 闪回数据查询
select * from flashback_transaction_query where table_name='TBL_PROGRAM' and operation='UPDATE'