- 存储过程如下:
- create or replace procedure proc_databack (deletetime in varchar2)
- as
-
- cursor mycursor is(select object_name from recyclebin where droptime like deletetime);
- temp_emp varchar2(2000);
- vflash_back varchar2(2000);
- begin
- open mycursor;
- loop
- fetch mycursor into temp_emp;
- exit when mycursor%notfound;
-
- vflash_back:='flashback table "'||temp_emp||'" to before drop';
-
- execute immediate vflash_back;
- end loop;
- close mycursor;
- end;
-
-
-
- /*
- declare
- time varchar2(20);
- begin
- time:='2011-12-02%';
- proc_databack (time);
- end;
- */