Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: selecting a record based on row id
Hi,
rowid changes too if you update the partition key of a prtitioned table (of course only after "alter table blah enable row movement;")
hth Stephan
Aparna schrieb:
> 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
> >
> >
-- Mit freundlichen Gr$B|_(Ben Stephan Langer, QITS GmbHReceived on Wed Sep 05 2001 - 08:00:05 CDT