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
Define Harvard Step Test - aerobic capacity? In this test, the subject steps on and off an 18-inch platform at a rate of 30 times per minute. The evaluator records the subject'

Q. Why is waste considered one of the major environmental issues? The environmental problem regarding waste worsens with industrial development and the global growth of consump

How does Respiration in animals

SELF - MEDICATION - Self medication refers to the use of medicines without consulting a physician. Self medication may be harmful, rather dangerous. It must be avoided. (i)

Br u c e ll osi s It is also called as Bang's disease or contagious abortion as it causes abortion in late pregnancy and infertility. E t iology: It is cause


Why Vegetable and Fruit are important for human body? The vegetables and fruits add colour and variety to our diets in addition to providing a host of essential nutrients and p

P n e u mo n i a It is inflammation of pulmonary parenchyma, usually accompanied by inflammation of bronchioles, and is characterized by cough, increased respiratory rat

The process of meiosis in animals is called gametogenesis .It takes place in the testis in male and ovary in female. Gametogenesis is divided into spermatogenesis (formation of

REDISCOVERY OF MENDEL'S LAWS (THE BIRTH OF GENETICS) 1.         It was in 1900 that three botanist independently rediscovered the principles of heredity already worked out by M