Jump to content

Portal:Computer programming/Selected article/10

Add links
From Wikipedia, the free encyclopedia
< Portal:Computer programming | Selected article

This is the current revision of this page, as edited by Σ (talk | contribs) at 05:54, 2 January 2012 (Image). The present address (URL) is a permanent link to this version.

(diff) ← Previous revision | Latest revision (diff) | Newer revision → (diff)

Null is a special marker used in Structured Query Language (SQL) to indicate that a data value does not exist in the database. Introduced by the creator of the relational database model, E. F. Codd, SQL Null serves to fulfill the requirement that all true relational database management systems (RDBMS) support a representation of "missing information and inapplicable information". Codd also introduced the use of the lowercase Greek omega (ω) symbol to represent Null in database theory. NULL is also an SQL reserved keyword used to identify the Null special marker.

Null has been the focus of controversy and a source of debate because of its associated three-valued logic (3VL), special requirements for its use in SQL joins, and the special handling required by aggregate functions and SQL grouping operators. Although special functions and predicates are provided to properly handle Nulls, opponents feel that resolving these issues introduces unnecessary complexity and inconsistency into the relational model of databases.

 This article incorporates text available under the CC BY-SA 3.0 license.

Retrieved from "https://en.wikipedia.org/w/index.php?title=Portal:Computer_programming/Selected_article/10&oldid=469068172"