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" <ORACLE-L_at_fatcity.com> 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: Jared.Still_at_radisys.com
>
> 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: ListGuru_at_fatcity.com (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: alexandre.gorbatchev_at_avermann.de

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: ListGuru_at_fatcity.com (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).