millions update

From: Seema Singh <oracledbam_at_hotmail.com>
Date: Fri, 22 Oct 2004 01:12:55 -0400
Message-ID: <BAY19-F11DAeys8FSA400001bbc@hotmail.com>

Hi,
I want to update millions of row.How to update in batch of 1000 rows Is following pl/sql ok?
declare
i pls_integer;
begin
i := 1000;
while i = 1000 loop
UPDATE MESSAGES set id=44178 where desc_code='F086' and id=33167 and rownum <1001;
i := sql%rowcount;
commit;
end;

thanks

---

Don’t just search. Find. Check out the new MSN Search! http://search.msn.click-url.com/go/onm00200636ave/direct/01/

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Oct 22 2004 - 00:08:38 CDT