Back in 1989, when I used to program with Oracle 5.2.3 on UNIX and VAX/VMS platforms, I considered SQL*PLUS as having the richest super-set of built-in functions. ORACLE*FORMS 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?
+3
A:
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 inOracleCROSS APPLYinSQL ServerDISTINCT ONinPostgreSQLON DUPLICATE KEY UPDATEinMySQL
Quassnoi
2010-06-30 13:33:51
@Quassnoi: OK, apart from those proprietary directives, which has the most comprehensive library of built-in functions, e.g. NVL(..), TODATE(..),SOUNDEX, DECODE, ENCRYPT, etc?
Frank Computer
2010-06-30 13:49:54
@Frank: I really don't know how to count this. In terms of "the maximal number of recognized built-in functions", most probably it will be `PostgreSQL`.
Quassnoi
2010-06-30 13:56:08
@Quassnoi: OK, not so much max, rather functionally useful!.. would you agree that Oracle was the pioneer in offering a robust super-set of SQL and continues to provide the richest set?
Frank Computer
2010-06-30 17:45:44
@Frank Computer: "would you agree that Oracle was the pioneer in offering a robust super-set of SQL and continues to provide the richest set?" That question is now different from your original question "At present, which other RDBMS' have come close, have the same, or more functionality than Oracle's SQLPLUS?". That makes the original question a very subjective one
Hao
2010-07-01 00:06:15
+1
A:
DB2 has a complete Java virtual machine available for server side processing stored procedures, you don't get much more "complete" than that.
CouchDB uses JavaScript, can't get much more flexible and complete that that either.
fuzzy lollipop
2010-06-30 23:42:48