Re: Order rows

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" <alexandre.gorbatchev_at_avermann.de> Sent by: root_at_fatcity.com
05/16/2002 12:08 AM
Please respond to ORACLE-L  

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        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" <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).



-- 
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).