Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: selecting a record based on row id
It also changes if the table is moved to another tablespace as in ALTER
TABLE BLAH MOVE TABLESPACE BLAH;
In addition 63873 is not a valid value for a rowid, so along with daniel i
conclude that although the questionner is asking about rowid, that in fact
is not what is meant.
-- Niall Litchfield Oracle DBA Audit Commission UK "Aparna" <bliss_is_ignorance_at_hotmail.com> wrote in message news:3b9500de.0_at_news.tm.net.my...Received on Wed Sep 05 2001 - 06:21:15 CDT
> Peter,
>
> As mentioned by Amin, RowId will remain same for a row, unless you move
the
> table to another DB or drop the table and reimport it or such, as RowId is
> 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
> >
> >
>
>
![]() |
![]() |