Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Data from ROW_ID
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