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
Explain Negative Staining Technique? Here, a stain has a negatively charged chromophore that is repelled by the negative bacterial surface. It results in indirect staining of m

wolves are predators for hares the wolf population increases what happenes next?

What are the anatomical relationships between the organs of the female reproductive system from the external vulva to the ovaries? The external female genitalia is called the v

Retention of Soil Moisture The movement of water into and within the soil, moisture storing capacity of soils and the availability of moisture to plants are governed by soil pr

Define Interaction of niacin with other Nutrients? You may recall reading earlier that trypotophan present in dietary proteins is converted to niacin. There is an interdepend

The oxidation of substrates like free fatty acids (FFA), glucose, lactate and ketone bodies results in the energy of Adenosine triphosphate (ATP) and Creatine phosphate (CP). The s

How to Care of the Ventilated Patient Constant focused attention is required for the patient on mechanical ventilatory support. A good understanding of the problems that can a

Marine oils These oils typically contain large amounts of long - chain omega-3-polyunsaturated fatty acids, with up to six double bonds and they are usually rich in vitamins A

How does the substrate concentration affect the speed of enzymatic reactions? Initially as substrate concentration increases, the speed of the reaction enhances; this happens b

Define Water of oxidation or metabolic water? Water that arises from oxidation of foods within the body, which is referred to as water of oxidation or metabolic water. Water wh