Menu
Home
People
Places
Arts
History
Plants & Animals
Science
Life & Culture
Technology
Reference.org
SQL:2008
open-in-new
<h2 id="new-features">New features</h2> <p>Additions to the Foundation include </p> <ul><li>enhanced <a href="/facts/Merge_(SQL)/hI2rksDG">MERGE</a> and DIAGNOSTIC statements,</li> <li>the <a href="/facts/Truncate_(SQL)/BJ1lGPDv">TRUNCATE TABLE</a> statement,</li> <li>comma-separated WHEN clauses in a CASE expression,</li> <li>INSTEAD OF <a href="/facts/Database_trigger/yhI7KW6H">database triggers</a>,</li> <li>partitioned <a href="/facts/Join_(SQL)/Cxl5lxcR">JOIN</a> tables,</li> <li>support for various <a href="/facts/XQuery/47Ep0fSS">XQuery</a> <a href="/facts/Regular_expression/KFL3veHX">regular expression</a>/<a href="/facts/Pattern_matching/CEwptMs9">pattern-matching</a> features, and</li> <li>enhancements to derived column names.<a class="footnote-ref" id="fnref:2" href="#fn:2"><sup>2</sup></a></li></ul> <h2 id="documentation">Documentation</h2> <p>The SQL standards documentation is not freely available but may be purchased from the <a href="/facts/International_Organization_for_Standardization/IacYR7Yg">ISO</a> as <i>ISO/IEC 9075(1-4,9-11,13,14):2008</i>. </p> <h2 id="claims-of-conformance">Claims of conformance</h2> <p>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.<a class="footnote-ref" id="fnref:3" href="#fn:3"><sup>3</sup></a> </p> <h2 id="see-also">See also</h2> Wikibooks has a book on the topic of: <i>Structured Query Language</i> <ul><li><a href="/facts/Structured_Query_Language/UjQLJcYm">Structured Query Language</a></li></ul> <h2 id="external-links">External links</h2> <ul><li><a href="http://www.wiscorp.com/SQLStandards.html">Freely downloadable drafts of this standard</a></li></ul> <h2 id="references">References</h2> <ol> <li id="fn:1"><p>SQL:2008 now an approved ISO International Standard Archived 2011-06-28 at the Wayback Machine, a July 29th, 2008 blog post from a Sybase blog <a href="http://iablog.sybase.com/paulley/2008/07/sql2008-now-an-approved-iso-international-standard/" target="_blank">http://iablog.sybase.com/paulley/2008/07/sql2008-now-an-approved-iso-international-standard/</a> <a href="#fnref:1" class="footnote-back-ref">↩</a></p></li> <li id="fn:2"><p>SQL:2008 now an approved ISO International Standard Archived 2011-06-28 at the Wayback Machine, a July 29th, 2008 blog post from a Sybase blog <a href="http://iablog.sybase.com/paulley/2008/07/sql2008-now-an-approved-iso-international-standard/" target="_blank">http://iablog.sybase.com/paulley/2008/07/sql2008-now-an-approved-iso-international-standard/</a> <a href="#fnref:2" class="footnote-back-ref">↩</a></p></li> <li id="fn:3"><p>Oracle Compliance To Core SQL:2008 from Oracle Corporation <a href="https://docs.oracle.com/cd/E11882_01/server.112/e41084/ap_standard_sql003.htm#SQLRF55516" target="_blank">https://docs.oracle.com/cd/E11882_01/server.112/e41084/ap_standard_sql003.htm#SQLRF55516</a> <a href="#fnref:3" class="footnote-back-ref">↩</a></p></li> </ol>