beg to differ on rule 4 - Oracle does differentiate between nulls, zero
values and encapsulated whitespace - eg " " ...
-----Original Message-----
From: Sami Seerangan [mailto:[Email Address Removed] 30 April 2003 11:23
To: LazyDBA.com Discussion
Subject: Re: codd rules
See
http://members.aol.com/mbaddenda/art120.html
for a list of them
I would say we satisfy (if you do not use ANY of the
object relational stuff)
1.1 The foundation rule
1.2 Information rule
1.3 Guaranteed access rule
1.5 Dynamic catalogue rule
1.6 Comprehensive data sub-language rule
1.7 View updating rule ** v8 and up **
1.8 High-level language rule
1.9 Physical data independence rule
1.10 Logical data independence rule
1.11 Integrity independence rule
1.12 Distribution independence rule
1.13 Non-subversion rule
the one we don't is:
1.4 Systematic nulls rule
Null values are distinct from an empty character
string, a string of blank
characters, a zero or any other number, and must be
supported by representing
missing and/or inapplicable information in a
systematic way.
the empty character string in general is treated as a
NULL in Oracle.
--- Yavor Ivanov <[Email Address Removed] wrote:
> 12 rules
>
> Oracle CAN support them, depends on you DB
> (Orace is your DBMS).
>
> But no practical DB uses all of them.
>
> Rgds,
> Yavor
>
> puru pradhan wrote:
>
> > CODD has given 12 or 14 rules?
> >
> > Also Oracle supports all??
> >
> > TIA
> >
> >
>
________________________________________________________________________
> > Missed your favourite TV serial last night? Try
> the new, Yahoo! TV.
> > visit http://in.tv.yahoo.com
> >
> > --------
> > Oracle documentation is here:
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> > To unsubscribe: send a blank email to
> oracledba-[Email Address Removed] > To subscribe: send a blank email to
> oracledba-[Email Address Removed] > Visit the list archive:
> http://www.LAZYDBA.com/odbareadmail.pl
> > Tell yer mates about http://www.farAwayJobs.com
> > By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>
>
>
> --------
> Oracle documentation is here:
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to
> oracledba-[Email Address Removed] To subscribe: send a blank email to
> oracledba-[Email Address Removed] Visit the list archive:
> http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>
__________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com
--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
**********************************************************************
This is a commercial communication from Commerzbank AG.
This communication is confidential and is intended only for the person to
whom it is addressed. If you are not that person you are not permitted to
make use of the information and you are requested to notify
<mailto:LONIB.[Email Address Removed] immediately that you have
received it and then destroy the copy in your possession.
Commerzbank AG may monitor outgoing and incoming e-mails. By replying to
this e-mail you consent to such monitoring. This e-mail message and any
attached files have been scanned for the presence of computer viruses.
However, you are advised that you open attachments at your own risk.
This email was sent either by Commerzbank AG, London Branch, or by
Commerzbank Securities, a division of Commerzbank. Commerzbank AG is a
limited liability company incorporated in the Federal Republic of Germany.
Registered Company Number in England BR001025. Our registered address in
the UK is 23 Austin Friars, London, EC2P 2JD. We are regulated by the
Financial Services Authority for the conduct of investment business in the
UK and we appear on the FSA register under number 124920.
**********************************************************************
Oracle LazyDBA home page