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: Are rowids unique among tables?

Re: Are rowids unique among tables?

From: Steve McDaniels <steve.mcdaniels_at_sierra.com>
Date: Thu, 5 Oct 2000 17:08:48 -0700
Message-ID: <8rj562$bu9$1@spiney.sierra.com>

According to the Oracle8 Server SQL Reference, page 2-41:

Each row in the database has an address. :
You can examine a row's address by querying the pseudocolumn ROWID.

A ROWID is unique within the entire database.

<kal121_at_my-deja.com> wrote in message news:8rj4am$28m$1_at_nnrp1.deja.com...
> I know that rowids are unique within a given table, but are they unique
> among tables? I tried to verify this myself, but Oracle wouldn't let me.
>
> (works ok)
>
> SQL> select rowid from tab1;
>
> ROWID
> ------------------
> AAAA5bAAHAAAAFrAAA
> AAAA5bAAHAAAAFrAAB
>
> (does not work)
>
> SQL> select rowid from tab1 where rowid in (select rowid from tab2);
>
> select rowid from tab1 where rowid in (select rowid from tab2)
> *
> ERROR at line 1:
> ORA-01410: invalid ROWID
>
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Oct 05 2000 - 19:08:48 CDT

Original text of this message

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