²©¿ÍÊ×Ò³ ×¢²á ½¨ÒéÓë½»Á÷ ÅÅÐаñ ¼ÓÈëÓÑÇéÁ´½Ó
ÍÆ¼ö ͶËß ËÑË÷£º °ïÖú

ÎÒµÄÌì¿Õ

  zhifeiji512.cublog.cn

¹ØÓÚ×÷Õß
ÐÕÃû£ºÀî´«
Ö°Òµ£º³ÌÐòÔ±
ÄêÁ䣺23
¸öÐÔ½éÉÜ£ºÄÚÍâ¼æÓÐ
|| << >> ||
ÎҵķÖÀà


PL/SQLÓÅ»¯É¾³ý

ʹÓð󶨱äÁ¿µÄ·½·¨É¾³ý

ÎÒʹÓð󶨱äÁ¿µÄ·½·¨£¬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

·¢±íÓÚ£º 2008-05-08£¬ÐÞ¸ÄÓÚ£º 2008-05-08 10:56£¬ÒÑä¯ÀÀ137´Î£¬ÓÐÆÀÂÛ0Ìõ ÍÆ¼ö ͶËß


ÍøÓÑÆÀÂÛ
¡¡·¢±íÆÀÂÛ