From jkstill@cybcon.com Sat, 19 Jan 2002 14:07:50 -0800
From: Jared Still <jkstill@cybcon.com>
Date: Sat, 19 Jan 2002 14:07:50 -0800
Subject: Re: Codde's Rules and Oracle
Message-ID: <F001.003F4F46.20020119134018@fatcity.com>
MIME-Version: 1.0
Content-Type: text/plain



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@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@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@hotmail.com>
> > > Sent by: root@fatcity.com
> > > 01/18/02 02:30 AM
> > > Please respond to ORACLE-L
> > >
> > >
> > >         To:     Multiple recipients of list ORACLE-L
>
> <ORACLE-L@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@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@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@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@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).




