declare
2 cursor flash_recover is
3 select * from crm_tqms_sample
4 ;
5 t_recode crm_tqms_sample%rowtype;
6 begin
7 DBMS_FLASHBACK.ENABLE_AT_TIME(to_date('2010-12-14 20:00:00','yyyy-mm-dd hh24:mi:ss'));
8 open FLASH_RECOVER;
9 DBMS_FLASHBACK.DISABLE;
10 loop
11 FETCH FLASH_RECOVER INTO t_recode;
12 EXIT WHEN FLASH_RECOVER%NOTFOUND;
13 insert into crm_tqms_sample values(t_recode.a把字段名称权都写在这里);
14 end loop;
15 CLOSE FLASH_RECOVER;
16 commit;
17 end;
Oracle无权限误删回滚
最新推荐文章于 2022-09-13 21:27:52 发布