Re: selecting a record based on row id

I see in a post later in this thread what I needed. Thanks for the help! "Jon Schlatter" <*jon-schlatter_at_stamats.com> wrote in message news:tpcvcaohot35cb_at_corp.supernews.com...
> 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
> 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
> 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:48:04 CEST