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