question

OraLearner avatar image
OraLearner asked

What are Codd Rules ?

What are the Codd Rules and total how many are there and how many Oracle supports among them ? Thank you.

oracletheoryrdbms
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

2 Answers

·
KillerDBA avatar image
KillerDBA answered

There's a good Wiki article on Codd's rules:

Codd's Rules on Wiki

I believe Oracle supports a solid majority of the rules.

Some people say Oracle violates rule 6. I think Oracle violates rule 3 (empty string is impossible to discern from null? Or am I mistaken?). I wouldn't be surprised if there were facilities in it to violate rule 12 (every other RDBMS I've worked with includes cheats!).

I don't know of any definitive list of Oracle capability vs the rules. Why not ask your Oracle salesperson? Let him earn his commission check.

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Lars avatar image
Lars answered

Nice link, I have always thought that the Codd rule was "The key, the whole key and nothing but the key". As a memory line for building applications using a relational database.

1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

KillerDBA avatar image KillerDBA commented ·
LOL, thanks. I've got to write that one down for future reference.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.