Peter,
it works, coz that ROWID is a constant physical element and you can use it
like a real field.
Thanks,
Amin Emami
http://www.aminemami.f2s.com/
"Peter Henning" <henning_at_rz.uni-karlsruhe.de> wrote in message
news: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 - 10:37:00 CDT
