数据库标准规范是怎么确定的？

[guoheng90]

现在流行的数据库很多，如oracle,mysql sql server等。
他们的sql 语句都有些相似，如select ,update,delete 语句，那么这些sql 语句规范是怎么确定的呢？

[hebo2005]

有个SQL99的标准，这些数据库都符合标准的，不过一般都会加些各数据库专用的函数之类的

[simonezhlx]

比如：sql server 的top到了oracle 就只能通过rownum来实现了

[ACMAIN_CHM]

有国际的SQL92， SQL2003，SQL2006标准

但各厂商仍自行对标准进行自己的扩充和解释。


SQL Standards
Oracle strives to comply with industry-accepted standards and participates actively in
SQL standards committees. Industry-accepted committees are the American National
Standards Institute (ANSI) and the International Organization for Standardization
(ISO). Both ANSI and the ISO/IEC have accepted SQL as the standard language for
relational databases.
The latest SQL standard was adopted in July 2003 and is often called SQL:2003. One
part of the SQL standard, Part 14, SQL/XML (ISO/IEC 9075-14) was revised in 2006
and is often referred to as SQL/XML:2006.
Oracle SQL includes many extensions to the ANSI/ISO standard SQL language, and
Oracle Database tools and applications provide additional statements. The tools
SQL*Plus, SQL Developer, and Oracle Enterprise Manager enable you to run any
ANSI/ISO standard SQL statement against an Oracle database and any additional
statements or functions available for those tools

[hebo2005]

[Quote=引用 3 楼 acmain_chm 的回复:]
有国际的SQL92， SQL2003，SQL2006标准

但各厂商仍自行对标准进行自己的扩充和解释。


SQL Standards
Oracle strives to comply with industry-accepted standards and participates actively in
SQL standards committees. Industry-accepted committees are the American National
Standards Institute (ANSI) and the International Organization for Standardization
(ISO). Both ANSI and the ISO/IEC have accepted SQL as the standard language for
relational databases.
The latest SQL standard was adopted in July 2003 and is often called SQL:2003. One
part of the SQL standard, Part 14, SQL/XML (ISO/IEC 9075-14) was revised in 2006
and is often referred to as SQL/XML:2006.
Oracle SQL includes many extensions to the ANSI/ISO standard SQL language, and
Oracle Database tools and applications provide additional statements. The tools
SQL*Plus, SQL Developer, and Oracle Enterprise Manager enable you to run any
ANSI/ISO standard SQL statement against an Oracle database and any additional
statements or functions available for those tools
[/Quote]

原来是三个标准噢，我记错了
反正92的肯定都满足的

[wh62592855]

[Quote=引用 3 楼 acmain_chm 的回复:]
有国际的SQL92， SQL2003，SQL2006标准

但各厂商仍自行对标准进行自己的扩充和解释。


SQL Standards
Oracle strives to comply with industry-accepted standards and participates actively in
SQL standards committees. Industry-accepted committees are the American National
Standards Institute (ANSI) and the International Organization for Standardization
(ISO). Both ANSI and the ISO/IEC have accepted SQL as the standard language for
relational databases.
The latest SQL standard was adopted in July 2003 and is often called SQL:2003. One
part of the SQL standard, Part 14, SQL/XML (ISO/IEC 9075-14) was revised in 2006
and is often referred to as SQL/XML:2006.
Oracle SQL includes many extensions to the ANSI/ISO standard SQL language, and
Oracle Database tools and applications provide additional statements. The tools
SQL*Plus, SQL Developer, and Oracle Enterprise Manager enable you to run any
ANSI/ISO standard SQL statement against an Oracle database and any additional
statements or functions available for those tools
[/Quote]
学习~

[ojuju10]

每个数据库语法大部分都一样的，有部分语法不一样

[iqlife]

求同存异就是所谓的标准吧