Re: Using UPDATE with ROWNUM?

Jagjeet Singh wrote:
> begin
> loop
> update table set col1 = sequence.nextval where col1 is null and rownum
> < 1001;
> commit;
> end loop;
> end;
>

I don't know what this is other than one of the worst examples of PL/SQL I have seen in a very long time. And I teach students new to PL/SQL.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org