How many codds rule should oracle satisfies

Showing Answers 1 - 13 of 13 Answers


  • Jan 22nd, 2006

Hi Kulwant,

Thank you for this piece of information but can you please tell us what are the 11 rules oracle satisfies. If possible please provide us any site or link in this matter that will elaborate the things.

A quick response will be highly appreciated.



  Was this answer useful?  Yes


  • Feb 12th, 2006

Can I know that one rule which is not supported by oracle.
Regards Muthu

  Was this answer useful?  Yes

pranav kumar purbey

  • Apr 14th, 2006

Oracle can support codd's 11.5 rules.

View updated rules fully not supported in oracle.

  Was this answer useful?  Yes


  • Jul 19th, 2006


Oracle satisfies 11.5 of 12 codd's rules.

The DML Operations on a complex view is not possible directly.

because Oracle only update the Simple view But it will over come



  Was this answer useful?  Yes


  • Jul 19th, 2006

11.5 Rules

The updation on a complex view is not possible in oracle .That is the remining rule.But we can over come this on INstead of trigger



  Was this answer useful?  Yes

gouthami kodangal

  • Aug 15th, 2006

The min no of  codds rules an Rdbms should satisfy are 6 out of the 12.wherein the oracle satisfies 12 rules

  Was this answer useful?  Yes


  • Oct 5th, 2006

Non Subversion rule :

"If a relational system has a low-level (single-record-at-a-time) language, that low level cannot be used to subvert or bypass the integrity Rules and constraints expressed in the higher level relational language (multiple-records-at-a-time)."

The RDBMS should prevent users from accessing the data without going through the Oracle data-read functions.
In Rule 5 Codd stated that an RDBMS required a Query Language, however Codd does not explicitly state that SQL should be the query tool, just that there should be a tool, and many of the initial products had their own tools, Oracle had UFI (User Friendly Interface), Ingres had QUEL (QUery Execution Language) and the never released DB1 had a language called sequel, the acronym SQL is often pronounced such as it was sequel that provided the core functionality to SQL.
Even when the vendors eventually all started offering SQL the flavours were/are all radically different and contained wildly varying syntax. This situation was somewhat resolved in the late 80's when ANSI brought out their first definition of the SQL syntax.
This has since been upgraded to version 2 and now all vendors offer a standard core SQL, however ANSI SQL is somewhat limited and thus all RDBMS providers offer extensions to SQL which may differ from vendor to vendor

  Was this answer useful?  Yes


  • Mar 20th, 2013

Are you talking about EF Codds 12 rules?

I seem to recall that Oracle has satisfied MAX of 12, with the exception being that the empty string is treated as a NULL.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions