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

Home -> Community -> Usenet -> c.d.o.server -> Re: Using UPDATE with ROWNUM?

Re: Using UPDATE with ROWNUM?

From: Jagjeet Singh <jagjeet.malhi_at_gmail.com>
Date: Tue, 26 Jun 2007 17:33:51 -0700
Message-ID: <1182904431.906839.10630@k29g2000hsd.googlegroups.com>


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

Original text of this message

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