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_at_rz.uni-karlsruhe.de>
Date: Tue, 04 Sep 2001 17:20:44 +0200
Message-ID: <3B94F14C.5CA00FD_at_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 - 17:20:44 CEST