Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Are rowids unique among tables?
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