Re: selecting a record based on row id

[Quoted] It is in fact what I am looking for. I am in the process of moving a database from Oracle to SQL Server to do some testing during a conversion of [Quoted] the tables I get a data formatting error related to record 63,873 in the Oracle table. I do not know what data is contained in this particular records and I need to find another way to review and change the contents. Hence the need to find the ROWID. If you can offer any other sugesstions as [Quoted] to what I can do it would be greatly appreciated.

"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:3b960ab4$1$237$ed9e5944_at_reading.news.pipex.net...
> 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...
> > 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
> > >
> > >
> >
> >
>
>
Received on Wed Sep 05 2001 - 21:39:41 CEST