Re: How to add a primary key column

From: Lonnie Blevins <lblevins_at_regenstrief.org>
Date: Wed, 2 Jul 2003 08:38:51 -0500
Message-ID: <bdun9f$u2u$1@hood.uits.indiana.edu>

I did this once and I think it looked like

UPDATE table SET pk_table=SEQ_Table.NextVal;

"Ralf Zwanziger" <goldensurfer_at_gmx.de> wrote in message news:ims4gv4ccmpsb7eoeh4mu86i2knatu93p6_at_4ax.com...
> I have a Table without a primary key and want to add a primary key.
> The problem is: how to update the existing columns with unique number
> values? I have the table with a column PK_Table and a sequence
> SEQ_Table. I thought the following statement would do it:
>
> Update Table set PK_Table = (select SEQ_Table.NextVal from dual)
>
> but this only results in ORA-02287: Sequence not allowed here.
> Any idea how to solve the problem, maybe with a cursor in PL/SQL?
>
> Thanks,
> Ralf
>
Received on Wed Jul 02 2003 - 08:38:51 CDT