Re: SQL question, updating all rows

Create a sequence (Oracle object) and update table set newcol = seqname.nextval

James

In article <35853E72.541DE74A_at_crv.pechiney.fr>, aljamous_at_crv.pechiney.fr wrote:

>Hello,
>
>I have a table where I added a column, and I want this column to be
>the primary key of my table. I need then to update this column,
>adding a unique value for each row of my table.
>Can someone tell me how i can do this in SQL ?
>
>F-38340 Voreppe tel (cell): +33.(0)6.14.55.16.88
--

lorenzen_at_tiny.net             | Life is complex; it has
                              |   real and imaginary parts