Alexander,
OK, we're splitting hairs here. :)
Of course ROWID's are stored in indexes, the database
has to be able to locate the rows. They are an internal mechanism
and not part of the user data.
And yes they can be used, and safely in certain situations. Updating
a row in PL/SQL comes to mind. But they should never be stored in
a table for other than temporary utility usage.
Jared
"Alexandre Gorbatchev" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
05/16/2002 12:08 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: Re: Order rows
Jared,
Oracle gives you a chance to use it. And it's very common to use. Isn't
it?
There is no conception of phisical location in realational theory. I'm not
saying that pure theory is the best for practical use, though. :)
BTW, Oracle stores ROWID in indexes... instead of primary key (which is
stored only in case of indexes on IOT). Of course, that's speed up access,
but...
Alexandre
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, May 15, 2002 11:50 PM
> > In fact ROWID is the Oracle implementation and against RDBMS rules. :)
> > ROWID gives information about phisical location of the record. That
MUST
> NOT
> > be in PURE relational database. Nowadays, there is no pure relational
> > database implementation.
>
> That doesn't really count, as Oracle does not store that as part of the
> data. It
> is generated from datafile and datablock information at runtime.
>
> Jared
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Alexandre Gorbatchev
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
