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
Glucose-6-phosphate to Glucose Glucose-6-phosphate to Glucose : Glucose-6-phosphate  is converted to glucose  by glucose-6-phosphatase which is present in intestine, liver and

Gonorrhea Single doses of cefixime (Suprax) orally or ceftriaxone  (Rocephin)  intramuscularly (IM) are highly effective for uncomplicated anogenital or pharyngeal infection,

Why Meat and Poultry are important for human body? Meat and poultry are rich sources of proteins of high biological value. They do not contain carbohydrates. All

Q. How does the swim bladder of fishes work allowing fishes to control their depth under water? From Hydrostatics it is known that an object does not sink if its density is les

How many different molecules composed of (A) two (B) three, and (C) four amino acids, linked together by peptide bonds, can be made from the set of 20 naturally occurring amino aci

Describe the different types of respiratory organs found in annelids.

Metabolic Reactions  in the HMP Pathway The hexose monophosphate pathway is responsible for  the generation of a substantialfraction of the cytoplasmic NADPH required  for bios

Define Nutritional Requirement and Dietary Modifications in the Diet of the Elderlu? The nutritional status influences the age-related rate of functional decline in many organ

Define the effect of niacin deficiency on Skin? Dermatitis is the characteristic feature of the' disease, It is symmetrical in distribution. In early stages, a bright red eryt

Q. Can you explain Para-sternal View? Various congenital anamolies can be detected in this view are perimembranous VSD (transducer anbled towards right hip), doubly commit