Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> millions update

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US