millions update

  • From: "Seema Singh" <oracledbam@xxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Fri, 22 Oct 2004 01:12:55 -0400

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/

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

Other related posts: