Message-ID: <3B1E4507.BECA497F@logiball.deREMOVETHIS>
Date: Wed, 06 Jun 2001 16:58:15 +0200
From: Christof Kaiser <kaiser@logiball.deREMOVETHIS>
Organization: Logiball Gmbh
X-Mailer: Mozilla 4.73 [en] (WinNT; U)
X-Accept-Language: de-DE,en
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.misc
Subject: Re: A tricky update...
References: <5c5c8561.0106060646.15f1035@posting.google.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 20
NNTP-Posting-Host: 193.97.215.143
X-Trace: 991839467 businessnews.de.uu.net 14098 193.97.215.143
X-Complaints-To: abuse@de.uu.net


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