From: benetnasch@blimey.co.uk (Benetnasch)
Newsgroups: comp.databases.oracle.misc
Subject: A tricky update...
Date: 6 Jun 2001 07:46:07 -0700
Organization: http://groups.google.com/
Lines: 9
Message-ID: <5c5c8561.0106060646.15f1035@posting.google.com>
NNTP-Posting-Host: 195.40.118.192
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 991838768 20430 127.0.0.1 (6 Jun 2001 14:46:08 GMT)
X-Complaints-To: groups-support@google.com
NNTP-Posting-Date: 6 Jun 2001 14:46:08 GMT


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