SQL:2003: Difference between revisions

Revision as of 08:51, 15 January 2009

Revision as of 22:09, 18 January 2009

Line 26:

** [http://www.iso.org/iso/en/CatalogueDetailPage.CatalogueDetail?CSNUMBER=35341 ISO/IEC 9075-14:2003] – XML-Related Specifications (SQL/XML)

==DBMS compliance==

Since the SQL:2003 standard is relatively new, few [[DBMS]] implementations are able to claim full compliance with it yet. However, most vendors have partial compliance with the core SQL:2003 features, for example [[data dictionary]] functions, and sometimes have legacy, non-standard syntax equivalents that they had introduced prior to the SQL:2003 standard.

* [[Oracle database|Oracle]] <ref>{{cite web|url=http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14200/ap_standard_sql003.htm|title=Oracle Compliance To Core SQL:2003|publisher=Oracle|accessdate=2007-05-27}}</ref>

* [[PostgreSQL]] <ref>{{cite web|url=http://developer.postgresql.org/pgdocs/postgres/features.html|work=PostgreSQL 8.3devel Documentation|title=PostgreSQL: SQL Conformance|publisher=PostgreSQL.org|accessdate=2007-05-27}}</ref><ref>{{cite web|url=http://developer.postgresql.org/pgdocs/postgres/unsupported-features-sql-standard.html|work=PostgreSQL 8.3devel Documentation|title=PostgreSQL: Unsupported Features|publisher=PostgreSQL.org|accessdate=2007-05-27}}</ref><ref>{{cite web|url=http://developer.postgresql.org/pgdocs/postgres/features-sql-standard.html|work=PostgreSQL 8.3devel Documentation|title=PostgreSQL: Supported Features|publisher=PostgreSQL.org|accessdate=2007-05-27}}</ref>

* [[MySQL]] <ref>{{cite web|url=http://dev.mysql.com/doc/refman/5.0/en/stored-procedures.html|title=MySQL Documentation on Stored Procedures|publisher=MySQL|accessdate=2007-08-14|quote=MySQL follows the SQL:2003 syntax for stored routines, which is also used by IBM's DB2.}}</ref>

* [[Firebird (database server)]] <ref>{{cite web|url=http://www.firebirdsql.org/index.php?op=devel&sub=engine&id=SQL_conformance|title=SQL Standard Conformance|publisher=Dmitry Yemanov(Firebird Foundation)|accessdate=2006-02-11|quote=This document outlines how much Firebird conforms to the current SQL standard.}}</ref>

* [[JavaDB|Apache Derby]] <ref>{{cite web|url=http://wiki.apache.org/db-derby/SQLvsDerbyFeatures|title=Derby Features|publisher=Apache}}</ref>

* [[Ingres]]<ref>{{cite web|url=http://www.ingres.com/products/ingres-database.php|title=Ingres Database|publisher=Ingres}}</ref>

{{Expand list|date=August 2008}}

==References==