flashback off下delete和update表的恢复(flashback query技术)
SQL> create table emp (id number,name varchar2(100),salary number);
Table created. SQL> insert into emp values(1,'zhang',100); 1 row created. SQL> insert into emp values(2,'jiao',100); 1 row created. SQL> commit; Commit complete. SQL> alter session set nls_date_format='hh24:mi:ss'; SQL> select sysdate from dual;
------------------------------------------------------------------------------------------------ update回之前指定列的恢复 update emp e1 set e1.salary=(select salary from emp as of timestamp to_timestamp('2012-04-15 16:04:12','yyyy-mm-dd hh24:mi:ss') e2 ?where e1.id=e2.id ) commit; (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |