The question of NULLs can be very confusing to the database user, so let us set down the basic principles. Generally speaking, a NULL is a special value that is used for two reasons:
To indicate that a value is missing or unknown
To indicate that a value is not applicable in the current context