declare
i integer;
begin
loop
execute immediate 'delete from trace_keyword_in_day where visit_day = to_date(''2011-06-12'' , ''yyyy-mm-dd'') and ROWNUM <5000 ';
commit;
select count(*) into i from trace_keyword_in_day where visit_day = to_date('2011-06-12' , 'yyyy-mm-dd');
exit when i = 0;
end loop;
end;
纯粹做备份