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