ʹÓð󶨱äÁ¿µÄ·½·¨É¾³ý
ÎÒʹÓð󶨱äÁ¿µÄ·½·¨£¬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£®¸ù¾ÝÓû%A