Re: Data from ROW_ID

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
/ Received on Thu Sep 11 1997 - 00:00:00 CDT