Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Check constraint condition

terrencecahillAug 12 2019 — edited Aug 21 2019

In Oracle online docs (http://docs.oracle.com/cd/B19306_01/server.102/b14200/clauses002.htm), it's stated that :

     To satisfy the constraint, each row in the table must make the condition either TRUE or unknown (due to a null).

What does the part of the sentence in bold mean? What I understand is that (since three value logic is implemented in Oracle DB) : to satisfy the constraint, each row in the table must make the condition either TRUE or NULL.

Am I correct or am I missing something?

Comments
Post Details
Added on Aug 12 2019
10 comments
949 views