flashback query的例子

sqlplus test/test
select * from C;
exit

sqlplus / as sysdba
select current_scn from v$database;
exit

sqlplus test/test
delete from C;
commit
select * from C as of scn xx;
exit

另一种方式是as of timestamp
SQL> alter session set nls_date_format='YYYY-MM-DD hh24:mi:ss';Session altered.SQL> select sysdate from dual;SYSDATE-------------------2012-06-22 09:40:37
select * from C as of timestamp to_timestamp('2012-06-22 09:40:37','YYYY-MM-DD hh24:mi:ss');