The Database Design Resource Center

Comments for But null IS a value!

Average Rating starstarstarstarstar

Click here to add your own comments

Nov 06, 2015
Thanks for posting this NEW
by: Anonymous

I hope you can continue this type of hard work to this site in future also. Because this blog is really very informative look at my profile and it helps me lot.

Aug 06, 2015
starstarstarstarstar NEW
by: body

Loved to read your blog. I would like to suggest you that traffic show most people read blogs on Mondays. So it should encourage blogger to write new write ups over the weekend primarily
Although this chat is relatively old, it was interesting to read ...

May 07, 2015
Guiding info NEW
by: Gaylord

The basic fact about education is that it give us the lesson which makes sense and which is completely logical for our daily dealings but if we look in our society then we can easily found that people do a lot of wrong work on the name of education. To visit rush essay writing services in which you can get good grade in your writing.

Sep 26, 2010
If it is not a "value", why can I reproduce it?
by: Steve Cosner

Alf, removing "value" from the phrase changes nothing. The fact that creating an empty spot in a row in a database is a reproducible event, and the fact that I can write pl/sql commands that recognize the (non) value and perform the same steps based on that "value" make null a value.

A null set is something that can be talked about, defined, represented, etc etc.

I am just trying to point how silly it is to create special phrases like IS NULL and force everyone to use them rather than allow A = Null.

There is no benefit to three-value logic except to satisfy the purists, and I doubt they do much real-world programming.

Sep 26, 2010
NULL is not a value: Please excuse me ;-)
by: Alf

It is my fault to use the words "NULL value". I used the word "value" because it is so often used. I will edit my article and remove. The implication of NULL is simply not having a value/unknown, and this is widely reckognized in the DB world.

Click here to add your own comments

Join in and write your own page! It's easy to do. How? Simply click here to return to On NULL values.

Return to But null IS a value!.

Exclusive interviews with:
Steven Feuerstein, PLSQL expert
Donald Burleson, Top IT consultant

Free eBook

Subscribe to my newsletter and get my ebook on Entity Relationship Modeling Principles as a free gift:

What visitors say...

"I just stumbled accross your site looking for some normalization theory and I have to say it is fantastic.

I have been in the database field for 10+ years and I have never before come across such a useful site. Thank you for taking the time to put this site together."

Mike, USA

Read more Testimonials

Database Normalization eBook:

Database Normalization eBook

Copyright © / Alf A. Pedersen
All rights reserved.
All information contained on this website is for informational purposes only.
Disclaimer: does not warrant any company, product, service or any content contained herein.

Return to top

Copyright acknowledgement note:

The name Oracle is a trademark of Oracle Corporation.
The names MS Access/MS SQL Server are trademarks of Microsoft Corporation.
Any other names used on this website may be trademarks of their respective owners, which I fully respect.