SQL> select * from zzw_temp2;
未选定行
SQL> insert into zzw_temp2 values(1,100);
已创建 1 行。
SQL> insert into zzw_temp2 values(2,200);
已创建 1 行。
SQL> insert into zzw_temp2 values(3,300);
已创建 1 行。
SQL> commit;
提交完成。
SQL> select * from zzw_temp2;
ID SCORE
---------- ----------
2 200
3 300
1 100
SQL> select to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') from dual;
TO_CHAR(SYSDATE,'YY
-------------------
2009-08-20 14:49:46
SQL> delete from zzw_temp2;
已删除3行。
SQL> commit;
提交完成。
SQL> select to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') from dual;
TO_CHAR(SYSDATE,'YY
-------------------
2009-08-20 14:50:00
SQL> select * from zzw_temp2 as of timestamp to_timestamp('2009-08-20 14:49:46',
'yyyy-mm-dd hh24:mi:ss');
ID SCORE
---------- ----------
2 200
3 300
1 100
SQL> select * from zzw_temp2;
未选定行
SQL> insert into zzw_temp2
2 select * from zzw_temp2 as of timestamp to_timestamp('2009-08-20 14:49:46',
'yyyy-mm-dd hh24:mi:ss');
已创建3行。
SQL> commit;
提交完成。
SQL> select * from zzw_temp2;
ID SCORE
---------- ----------
2 200
3 300
1 100
SQL>
比较简单