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
Assessment of Peripheral Vascular Perfusion (Beside Test) Burger's Postural Test Perform in daylight.  Place patient supine with both legs elevated and knees

Q. Descriptions of the genera? A manual is a book that contains information on the area of coverage and keys and descriptions of the families, genera and species including the

Plants use proteins, lipids and starch as seed storage compounds. What is an advantage of using proteins as a storage compound that are not afforded by lipids or starch?

Define the Beer's Law - Nutritional  Biochemistry? Beer's law states that the concentration of a substance is directly proportional to the amount of light absorbed or inversely


DIFFERENCE S BETWEEN "A" AND "I" BANDS     A-Ban d (Anisotropic band)   I-Ban d (Isotropic band) 1. It

Q. What do you understand by Chromosome Behaviour? When we study meiosis. we not only observe the regularity of pairing which is important' for' the fertility of the plants, we

Q. What is Tricuspid valve annuloplasty? It depends upon the cause of tricuspid regurgitation. Specific therapy is directed towards the particular cause of pulmonary artery hyp

Anterior Leaflet Procedure: Repair is more difficult and less successful. Previously, a triangular excision of the anterior leaflet used to be done for prolapse and rupture of

Determine Effect of Inadequate calcium intake and iron deficiency anaemia? The requirement of iron and calcium is at its peak in adolescence due to an increase in the skeletal