Re: selecting a record based on row id

From: Peter Henning <henning_at_rz.uni-karlsruhe.de>
Date: Tue, 04 Sep 2001 17:20:44 +0200
Message-ID: <3B94F14C.5CA00FD@rz.uni-karlsruhe.de>

Hello,

> Is there a SQL Plus/PLSQL command to select a record based on row id? I have
> a table which has a single records with malformed data. The tables contains
> 140,000 records so it is difficult to review manually, but I know that
> record 63,873 has the bad data. How can I view/change just that record
> without knowing what specific data it contains.

What about this:

UPDATE table SET column=newvalue WHERE ROWID=xyz

But I'm not sure, if the rowid is always a constant

Ciao, Pit Received on Tue Sep 04 2001 - 10:20:44 CDT