Re: Using UPDATE with ROWNUM?

begin
loop
update table set col1 = sequence.nextval where col1 is null and rownum < 1001;
commit;
end loop;
end; Received on Tue Jun 26 2007 - 19:33:51 CDT