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
Q. How is the chromosome region where the centromere is located called, and how chromosomes classified in the relation to the position of their centromere? The chromosome regio

Q. Angiographic Findings and Interpretation? Pulmonary angiography is useful in the following clinical scenarios: 1) Pulmonary artery stenosis 2) Pulmonary arteriovenous

What is mechanical digestion? In molluscs, arthropods, earthworms, birds and vertebrates, in general, which organs respectively participate in this type of digestion? Mechanica

Q. What are the three major types of passive transport? The three main types of passive transport are simple osmosis, diffusion and facilitated diffusion.

Distribution Coefficient - Terminologies used in Chromatography? During the purification or separation of the biomolecules it should be kept in mind that two important factors

Explain Prosthetic device infections Some infectious disease specialists recommend antimicrobial prophylaxis before process in patients with vascular grafts or orthopedic pros

What is meant by "mutualist exploration of cellulose digestion", a phenomenon that occurs in some mammals and insects? Herbivorous animals eat great amounts of cellulose, a sub

Size of Ecosystem As you know an ecosystem may be as small and as simple as a cow dung pad or as complex and large as an ocean or the biosphere itself, comprising a wide variet

what will happen to a plant kept in dark for 72 hours

Organisational Behaviour of Health Care The insights provided by the theories of organisational behaviour emphasise the need for the establishment of institutional frameworks