Re: selecting a record based on row id
Date: Tue, 4 Sep 2001 20:07:00 +0430
Message-ID: <9n2sc5$4s7sq$1_at_ID-101160.news.dfncis.de>
Peter,
[Quoted] 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/
[Quoted] [Quoted] "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 - 17:37:00 CEST