Re: A tricky update...

UPDATE bad_table SET id=ROWNUM;

or ROWID
but i think rownum is nicer to read.

Regards
Christof

Benetnasch wrote:

> I have 2 rows in a table with exactly the information
> in them (badly designed, I know, but it's a legacy
> system). I need to update these rows so that a blank
> column is assigned a unique identifier. How can I
> run an SQL update on them to achieve this, please?
>
> Thanks for any information,
>
> Mark
  Received on Wed Jun 06 2001 - 09:58:15 CDT