Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Data from ROW_ID

Re: Data from ROW_ID

From: MarkP28665 <markp28665_at_aol.com>
Date: 1997/09/11
Message-ID: <19970911180700.OAA08692@ladder01.news.aol.com>#1/1

From: Erika Grondzakova <grondzak_at_fria.utc.skx> How could I retrieve data from table when I know ROW_ID ??? (for example ROW_ID is 00000005.0004.0005 - <<

Try:
select * from table_name
where rowid = ' 00000005.0004.0005';

You need the single quotes. There are examples in either the Concepts or DBA Admin guide. Strangely the SQL manual show how to retrieve it, but I did not find an example matching to it.

Mark Powell -- The only advise that counts is the advise that you follow so follow your own advise Received on Thu Sep 11 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US