Re: selecting a record based on row id

[Quoted] 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 [Quoted] conclude that although the questionner is asking about rowid, that in fact [Quoted] 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...


> 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

> >

> >

>

>