Re: Delete from...Commit redux
From: Ilia Bashtanov <iliab_at_mmc.ru>
Date: 1997/05/13
Message-ID: <01bc5fc2$704dc3d0$24d9bec2_at_ib>#1/1
Date: 1997/05/13
Message-ID: <01bc5fc2$704dc3d0$24d9bec2_at_ib>#1/1
> delete mem_month_by_period;
This statement will delete ALL rows
from mem_month_by_period TABLE !!!
Such block will solve you problem:
begin
loop
delete from mem_month_by_period where rownum < 100;
exit when sql%rowcount = 0;
commit;
end loop;
end;
-- Ilia BashtanovReceived on Tue May 13 1997 - 00:00:00 CEST