3.6. NULL Values

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