Re: Codde's Rules and Oracle

I admit to being on shaky ground on rule 11. See my comments in another post.

You *could* argue that 'instead of' triggers allow compliance with rule 7. Have you tried to implement it? It gets too complicated too fast.

This may be a case of being in compliance with the letter of the law while violating its spirit.

Jared

On Saturday 19 January 2002 12:10, Charles Wolfe wrote:
> One could argue that Oracle is compliant with rule 11. A distributed
> Oracle database can be constructed in such a way as to be transparent to
> end users.
>
> With the addition of 'INSTEAD OF' triggers in 8i, one could argue that
> Oracle is also compliant with rule 7.
>
> Just my $.02.
>
> Chuck
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Saturday, January 19, 2002 12:45 AM
>
> > Here's a URL for a list of the rules:
> >
> > http://luna.pepperdine.edu/~ckettemb/class/Codd12R.html
> >
> > After taking a quick glance at the rules, I think that Oracle fails
> > on 7 and 11, probably others, but those were the ones that stood
> > out without too much pondering. :)
> >
> > Jared
> >
> > On Friday 18 January 2002 09:51, Jared.Still_at_radisys.com wrote:
> > > No.
> > >
> > > In fact, I don't believe that there is a database in existence that
> > > does conform to all 12 rules.
> > >
> > > I'll let someone else answer the hard part, just not enough time for
>
> that.
>
> > > Jared
> > >
> > >
> > >
> > >
> > >
> > > "Vikas S" <vikas_s40_at_hotmail.com>
> > > Sent by: root_at_fatcity.com
> > > 01/18/02 02:30 AM
> > > Please respond to ORACLE-L
> > >
> > >
> > > To: Multiple recipients of list ORACLE-L
>
> <ORACLE-L_at_fatcity.com>
>
> > > cc:
> > > Subject: Codde's Rules and Oracle
> > >
> > >
> > >
> > > Dear All,
> > >
> > > Does Oracle confirm to all 12 Codde's Rules. Can
> > > anyone point out the Rules violated by each version (6/7/8/9) of
> > > Oracle.
> > >
> > > Thanks,
> > > Vikas
> > >
> > >
> > >
> > > _________________________________________________________________
> > > Chat with friends online, try MSN Messenger: http://messenger.msn.com
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Jared Still
> > INET: jkstill_at_cybcon.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: Jared Still
  INET: jkstill_at_cybcon.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).