现在流行的数据库很多,如oracle,mysql sql server等。
他们的sql 语句都有些相似,如select ,update,delete 语句,那么这些sql 语句规范是怎么确定的呢?
他们的sql 语句都有些相似,如select ,update,delete 语句,那么这些sql 语句规范是怎么确定的呢?
解决方案 »
- 再问一个union中SUM相加的问题
- 创建视图的时候group by的问题
- 給这表student分配50K的两个区,后续分配的区大小每次增长50%,最多只能分配100个区。
- 可以改下这个查询语句么?---散分的题目
- where a.id in (b.字段名),这种需求用SQL怎么写?
- 调用存储过程
- 很采的问题。小弟只有10分了,请各位见量。
- 我在安装oracle9.2版本出现的问题
- 如何把数据从oracle9i导入到oracle8中
- clob weblogic jdbc
- 安装oracle客户端11g和10g都安装失败
- oracle 10g数据库服务器IP发生改变后,监听及实例无法运行该如何解决?
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