SQL-92

Uses your system voice; voice and rate in settings.

Snapshot

≈ 3 min read

Names in other languages

No names in other languages are held for this entry yet.

Article bodies are English and are not machine-translated. A name in another language is not a translation of the article.

SQL-92 (also called SQL 2) was the third revision of the SQL database query language. Unlike SQL-89, it was a major revision of the standard. Aside from a few minor incompatibilities, the SQL-89 standard is forward-compatible with SQL-92. The standard specification itself grew about five times compared to SQL-89. Much of it was due to more precise specifications of existing features; the increase due to new features was only by a factor of 1.5–2. Many of the new features had already been implemented by vendors before the new standard was adopted. However, most of the new features were added to the "intermediate" and "full" tiers of the specification, meaning that conformance with SQL-92 entry level was scarcely any more demanding than conformance with SQL-89. The next revision is SQL:1999 (SQL3).

SQL-92 (also called SQL 2) was the third revision of the SQL database query language. Unlike SQL-89, it was a major revision of the standard. Aside from a few minor incompatibilities, the SQL-89 standard is forward-compatible with SQL-92. The standard specification itself grew about five times compared to SQL-89. Much of it was due to more precise specifications of existing features; the increase due to new features was only by a factor of 1.5–2. Many of the new features had already been implemented by vendors before the new standard was adopted. However, most of the new features were added to the "intermediate" and "full" tiers of the specification, meaning that conformance with SQL-92 entry level was scarcely any more demanding than conformance with SQL-89. The next revision is SQL:1999 (SQL3).

Related official standard

ANSI X3.135-1992 ISO/IEC 9075:1992 FIPS PUB 127-2

New features

Significant new features include: New data types defined: DATE , TIME , TIMESTAMP , INTERVAL , BIT string, VARCHAR strings, and strings. Support for additional character sets beyond the base requirement for representing SQL statements. New scalar operations such as string concatenation and substring extraction, date and time mathematics, and conditional statements. New set operations such as UNION , UNION ALL , CROSS JOIN , and formalized JOIN types ( INNER JOIN , LEFT JOIN , RIGHT JOIN , FULL OUTER JOIN ). Conditional expressions with CASE . For an example, see Case (SQL). Support for alterations of schema definitions via ALTER and DROP . Bindings for C, Ada, and MUMPS. New features for user privileges. New integrity-checking functionality such as within a CHECK constraint. A new information schema—read-only views about database metadata like what tables it contains, etc. For example, . Dynamic execution of queries (as opposed to prepared). Better support for remote database access. Temporary tables; etc. Transaction isolation levels. New operations for changing data types on the fly via . Scrolled cursors. Compatibility flagging for backwards and forwards compatibility with other SQL standards.

References

External links

The SQL-92 standard

Text derived from https://en.wikipedia.org/w/index.php?oldid=1323198231 under CC BY-SA 4.0; modifications have been made.

Sources cited in this revision

2 named source(s) extracted from the cited revision. A source with no author is shown by its publication; nothing is invented.