使用绑定变量的方法删除
我使用绑定变量的方法，90W条记录用了5分钟
具体的如下：
create or replace procedure del_forall
tyep ridArray is table of rowid index by integer;
type dtArray is table of varchar2(50) index by integet;
v_rowid ridArray;
v_mid_to_delete dtArray;
begin
select mid ,rowid bulk collect into v_mid_to_delete,v_rowid from temp_mid_bak where rownum<10000;
forall i in 1.. v_mid_to_delte.COUNT
delete from ssf where mid_v_mid_to_delete(i);
end;
/
=================================================================================
1．根据用
阅读(865) | 评论(0) | 转发(0) |
