Back in 1989, when I used to program with Oracle 5.2.3 on UNIX and VAX/VMS platforms, I considered SQLPLUS as having the richest super-set of built-in functions. ORACLEFORMS also had the ability to embed SQL statements within triggers. That was then, 21 years ago. At present, which other RDBMS' have come close, have the same, or more functionality than Oracle's SQLPLUS, DB2?.. SQL-Server?.. T-SQL?.. MySQL?.. etc?
早在1989年，当我在UNIX和VAX/VMS平台上使用Oracle 5.2.3编程时，我认为SQLPLUS拥有最丰富的内置函数集。ORACLEFORMS还可以在触发器中嵌入SQL语句。那是21年前的事了。目前，有哪些RDBMS比Oracle的SQLPLUS DB2具有相同或更多的功能?sql server ? . .t - sql ? . .MySQL ? . .等等?
2 个解决方案
#1
3
It's hard to tell what is "richest". All systems have some proprietary things which the other systems don't support, including, but not limited to:
很难说什么是“最富有的”。所有系统都有一些专有的东西，其他系统不支持，包括但不限于:
-
MODELclause inOracle - 在Oracle模型条款
-
CROSS APPLYinSQL Server - 在SQL Server中交叉应用
-
DISTINCT ONinPostgreSQL - 在PostgreSQL截然不同
-
ON DUPLICATE KEY UPDATEinMySQL - 在MySQL中复制密钥更新
#2
1
DB2 has a complete Java virtual machine available for server side processing stored procedures, you don't get much more "complete" than that.
DB2有一个完整的Java虚拟机，可以用于服务器端处理存储过程，没有什么比这更“完整”了。
CouchDB uses JavaScript, can't get much more flexible and complete that that either.
CouchDB使用的是JavaScript，不能变得更加灵活和完整。
#1
3
It's hard to tell what is "richest". All systems have some proprietary things which the other systems don't support, including, but not limited to:
很难说什么是“最富有的”。所有系统都有一些专有的东西，其他系统不支持，包括但不限于:
-
MODELclause inOracle - 在Oracle模型条款
-
CROSS APPLYinSQL Server - 在SQL Server中交叉应用
-
DISTINCT ONinPostgreSQL - 在PostgreSQL截然不同
-
ON DUPLICATE KEY UPDATEinMySQL - 在MySQL中复制密钥更新
#2
1
DB2 has a complete Java virtual machine available for server side processing stored procedures, you don't get much more "complete" than that.
DB2有一个完整的Java虚拟机，可以用于服务器端处理存储过程，没有什么比这更“完整”了。
CouchDB uses JavaScript, can't get much more flexible and complete that that either.
CouchDB使用的是JavaScript，不能变得更加灵活和完整。