Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Data from ROW_ID
Matt Southcott wrote:
>
> On Thu, 11 Sep 1997 17:38:18 +0200, Erika Grondzakova
> <grondzak_at_fria.utc.skx> wrote:
>
> >
> >Hi,
> >
> >How could I retrieve data from table when I know ROW_ID ???
> >
> >(for example ROW_ID is 00000005.0004.0005 - this is from the table
> >exceptions,
> > generated during enabling constraint after IMPORT.)
> >
> >Thank you in advance
> >
> > Erika
> > grondzak_at_fria.utc.sk
>
> Row_id is like a hidden column in all tables it just tells oracle the
> quickest way to find the info. It contains the slice and block and
> segment info.
>
> SELECT* FROM "table of your choice"
> WHERE row_id = balahblahblah
> /
In some instances of Pro*C/Pro*Cobol you have to define a variable that holds 18 characters and use the ROWIDTOCHAR and CHARTOROWID functions, i.e.
SELECT * FROM "table of your choice"
WHERE row_id = CHARTOROWID(:host_rowid)
Received on Thu Sep 18 1997 - 00:00:00 CDT
![]() |
![]() |