Re: selecting a record based on row id

Peter,

[Quoted] [Quoted] As mentioned by Amin, RowId will remain same for a row, unless you move the [Quoted] [Quoted] table to another DB or drop the table and reimport it or such, as RowId is [Quoted] [Quoted] the physical location of the row....

Regards,
Aparna
"Amin Emami" <Amin_Emami_at_yahoo.com> wrote in message news:9n2sc5$4s7sq$1_at_ID-101160.news.dfncis.de...
> 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 - 18:23:19 CEST