null value


Also found in: Dictionary, Thesaurus, Medical, Legal, Acronyms.

null value

A value in a field or variable that indicates nothing was ever derived and stored in it. For example, in a decimal-based amount field, a null value might be all binary 0s (null characters), but not a decimal 0. The decimal 0 would imply no dollars and cents, which could in fact be a valid derived value. See null and binary.
References in periodicals archive ?
Only update statement of temporal column sets not null value.
You may also have a case for a null value if you are working in a database and none of its values has a record.
The value NULL should not be placed within quotation marks because it will be interpreted as the character string 'NULL', rather than the null value.
iL], as any one of them takes a null value, a 0 estimate will necessarily result, although other parameters can show high values.
The null value function (NVL), which returns either the input value or an alternate value in the case where the input has a null value, may be used when a null value is unacceptable.
The expected null value was obtained by a Monte Carlo simulation in which the computer generated 1,000 bogus experiments of 48 sessions each, utilizing the same software used in the actual experiment and sampling from a population of key game designations (1-4) consisting of the 139 real targets.
In the case in which we use a simple null hypothesis with a composite alternative, and variation in the parameter values can be on both sides of the null value, then we have a two-sided test.
In the first case, the conditional compilation includes code to check whether an already linked node is being used, because it contains a non NULL value, or whether an unlinked node is being decoupled from the container, when the link field is already NULL.
In the three-valued logic of SQL, the result of comparing a NULL value is UNDEFINED [ANSI 1992; Melton and Simon 1993].
The constraints include the designation of node keys for the form hierarchy, null value permission, default values, and value ranges, if numeric, and enumerated values if nominal.