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
Oxidation Some enzymes which have the sulfhydryl (-SH)  group in  the catalytic site are very sensitive to oxidation. Due  to oxidation of  the  -SH  group  by  aerial  oxygen

Why acquired traits are not directly related to the process of evolution? As acquired traits are not genetically determined, they cannot be passed on to offspring. Therefore,

a) Where casparian strips situated in a plant body are and what are they made up of? Mention its function. b) What is respiration quotient (RQ)? Under what conditions will th

Define Requirements of Chromium? There is no Recommended Dietary Allowance (RDA) for chromium but adequate intakes that can be used as a goal for individual intakes has been pr

Explain the process by which the kidney varies the volume and concentration of urine

Q. What is tertiary structure of a protein? What are the major types of tertiary structure? The tertiary protein structure is a spatial conformation additional to the secondary

How is the circulatory system of reptiles characterized? What is the basic difference among the reptile and the amphibian heart? The circulatory system of beings of the class R

In studies of human body, which of the below terms is used to describe the first step in production of urine? Is it: a) Tubular reabsorption b) Tubular secretion c) Glome

Q. What are some major differences of the vertebrate nervous systems comparing to invertebrates? In vertebrates the nervous system is well-characterized, having dorsal neural c

What are plasmids? The Plasmids are circular DNA molecules present in the genetic material of some bacteria. They may perhaps contain genes responsible for bacterial resistance