Re: Order rows

Agree. We are talking the same things :)

Alexandre

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