|This section needs expansion. You can help by adding to it. (February 2011)|
The SQL:2008 standard is split into several parts, covering the Framework, the Foundation, the Call-Level Interface, Persistent Stored Modules, Management of External Data, Object Language Bindings, Information and Definition Schemas, Routines and Types Using Java, and various "Related Specifications."
Additions to the Foundation include
- enhanced MERGE and DIAGNOSTIC statements,
- the TRUNCATE TABLE statement,
- comma-separated WHEN clauses in a CASE expression,
- INSTEAD OF database triggers
- partitioned JOIN tables,
- support for various XQuery regular expression/pattern-matching features, and
- enhancements to derived column names.
The Related Specifications for XML defines ways in which SQL can be used in conjunction with XML, including importing and storing XML data in an SQL database, manipulating it within the database and publishing both XML and conventional SQL-data in XML form.
The SQL standard is not freely available. The whole standard may be purchased from the ISO as ISO/IEC 9075(1-4,9-11,13,14):2008. The standard consists of the following parts:
- ISO/IEC 9075-1:2008 Framework (SQL/Framework)
- ISO/IEC 9075-2:2008 Foundation (SQL/Foundation)
- ISO/IEC 9075-3:2008 Call-Level Interface (SQL/CLI)
- ISO/IEC 9075-4:2008 Persistent Stored Modules (SQL/PSM)
- ISO/IEC 9075-9:2008 Management of External Data (SQL/MED)
- ISO/IEC 9075-10:2008 Object Language Bindings (SQL/OLB)
- ISO/IEC 9075-11:2008 Information and Definition Schemas (SQL/Schemata)
- ISO/IEC 9075-13:2008 SQL Routines and Types Using the Java TM Programming Language (SQL/JRT)
- ISO/IEC 9075-14:2008 XML-Related Specifications (SQL/XML)
Claims of conformance
The minimum level of conformance to SQL:2008 that a product can claim is called "Core SQL:2008" and is limited to definitions specified in two parts of the standard: the Foundation and the Information and Definition Schemas.
- SQL:2008 now an approved ISO International Standard, a July 29th, 2008 blog post from a Sybase blog
- International Organization for Standardization: "ISO/IEC 9075-14:2008"
- Oracle Compliance To Core SQL:2008 from Oracle Corporation