Sql''s fifth concept - null, Biology

SQL's Fifth Concept - NULL

Unfortunately, SQL embraces a fifth concept, called NULL, an apparently simple little thing but one that has pervasive effects on our usual understanding of the other four. NULL denotes a kind of nothingness. It is somewhat akin to a value in that it can be the result of evaluating an expression, but it has no type, cannot appear everywhere a value can appear, and lacks certain other properties that values have, as we shall see.

Although SQL is not the only computer language to include a special construct representing non- existence, its own variety, NULL is accompanied by a departure from classical logic that is not found in any other well-known languages and gives rise to some deviations from relational database theory that students and users have to be well aware of. The departure in question is the introduction of a third truth value, denoted by the key word UNKNOWN. For example, a comparison of the form x = y in SQL evaluates to UNKNOWN if either x or y evaluates to NULL, even when they both do! (The comparison operator IS NOT DISTINCT FROM is available in place of =, such that x IS NOT DISTINCT FROM y evaluates to FALSE if just one of x and y is NULL, TRUE if they both are, and is otherwise equivalent to x = y.)


Posted Date: 1/18/2013 1:33:10 AM | Location : United States

Related Discussions:- Sql''s fifth concept - null, Assignment Help, Ask Question on Sql''s fifth concept - null, Get Answer, Expert's Help, Sql''s fifth concept - null Discussions

Write discussion on Sql''s fifth concept - null
Your posts are moderated
Related Questions
what are the characteristics of cleavage formed in coelenterates?

Empiric Initial Therapy  Until susceptibility results are available, empiric initial treatment consists of a 4-drug regimen of isoniazid, rifampin, pyrazinamide and ethambutol.

What happens to the TSH (thyroid-stimulating hormone) blood level in hypothyroidism? Why is there enlargement of the thyroid in the endemic goiter disease? When there is low T3

Pulse wave  transducer has one Doppler  crystal. This crystal emits a short burst of ultrasound at a certain frequency [PULSE REPETITION FREQUENCY (PRF)].  The ultrasqund is reflec

Microfilaments comprise of the proteins The microfilaments comprise of the proteins, actin and myosin, the same contractile proteins that are found in skeletal muscle cells. Si

You have discovered a novel alternatively spliced gene (gene X) and you wish to study its regulation in an in vitro splicing assay.  The alternatively spliced product retains intro

Why, even though they have an open circulatory system, can flying insects like flies beat their wings with great speed? In insects the circulatory system is open but this syste

Vitamins Vitamins, as you may already know, derive its name from the word 'Vital Amine'. These are the organic compounds required for normal metabolism, growth and developme

What is Lymphatic System in human biology? The lymphatic system maintains fluid balance and serves in protecting the body from disease. The primary organs of the lymphatic syst