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/
--
http://www.freelists.org/webpage/oracle-l
- Follow-Ups:
- Re: millions update
- From: Jared Still
Other related posts:
- » millions update
- » Re: millions update
- Re: millions update
- From: Jared Still