Oracle Flashback table的使用 - 数据库编程

ues(2); 1 row created. 18:33:10 SQL> insert into tab03 values(3); 1 row created. 18:33:12 SQL> commit; Commit complete. 18:33:14 SQL> 18:33:16 SQL> insert into tab03 values(4); 1 row created. 18:33:23 SQL> commit; Commit complete. 18:33:25 SQL> select * from tab03; ID ---------- 1 2 3 4

18:35:33 SQL> FLASHBACK TABLE TAB03 TO timestamp to_timestamp('2013-11-29 18:33:25','yyyy-mm-dd hh24:mi:ss');

Flashback complete.

18:35:39 SQL> select * from tab03;

        ID
----------
         1
         2
         3

18:35:40 SQL>




 FLASHBACK TABLE TAB03 TO timestamp to_timestamp('2013-11-29 18:33:30','yyyy-mm-dd hh24:mi:ss');

Flashback complete.

18:35:54 SQL> select * from tab03;

        ID
----------
         1
         2
         3
         4

18:35:55 SQL> FLASHBACK TABLE TAB03 TO timestamp to_timestamp('2013-11-29 18:33:25','yyyy-mm-dd hh24:mi:ss');

Flashback complete.

18:35:59 SQL> select * from tab03;

        ID
----------
         1
         2
         3

Oracle Flashback table的使用(二)