Oracle 存储过程删除大表记录
Oracle 存储过程删除大表记录
Oracle 存储过程删除大表记录:
create or replace procedure whxd
as
begin
loop
delete from sj where t<to_date('2011-07-12 10:40:49','yyyy-mm-dd hh24:mi:ss') and rownum<1000;
exit when SQL%ROWCOUNT=0;
commit;
end loop;
exception
when others then
rollback;
return;
end;
评论暂时关闭