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
Preputial prolapse This deformity is seen in some of the tropical zebu breeds but is not uncommon in European breeds. Initially, it begins as a temperory eversion of a small p

Define the lens transparency in metabolism of lens. Lens Transparency: a. Transparency depends on avoidance of large transitions of refractory index. This is in other wor

Normal 0 false false false EN-IN X-NONE X-NONE MicrosoftInternetExplorer4

Could any of the following features be useful in a gateway vector; (i) Origin of replication (ii) multiple cloning site (iii) blue/white selection (iv) M13 forward and rev

Organogenesis - Plant Tissue and Organ Culture Organogenesis refers to the differentiation of organs such as roots, shoots or flowers. Shoot bud differentiation may occur dire

What are the most significant inorganic molecular substances for living beings? The most significant inorganic substances for living beings are mineral salts, water, carbon dio

description of first five phylum

Q. Which is the brain region that receives conscious sensory information? Which is the brain region that triggers the voluntary motor activity? In the brain conscious sensory i

Write about embryonic stem cell invitro methord in which transgenic animal were generated and efficient show how homologous recombination happening?

Parthenogenesis The diploid egg produced in the embryo sacs during diplospory and apospory develops into an embryo without fertilization, thus maintaining the sporophytic lev