All geek questions in one place

Which RDBMS has the richest ANSI-SQL super-suite?

Back in 1989, when I used Oracle 5.2.3 on UNIX and VAX / VMS, I thought SQLPLUS had the richest super-suite of built-in functions. ORACLEFORMS also has the ability to embed SQL statements in triggers. That was then, 21 years ago. Currently, which other RDBMSs have come close, have the same or greater functionality than Oracle SQLPLUS, DB2? .. SQL-Server? .. T-SQL? .. MySQL? .. etc.?

+3
source share
2 answers

It’s hard to say what the “richest” is. All systems have some proprietary things that other systems do not support, including but not limited to:

  • MODEL at Oracle
  • CROSS APPLY at SQL Server
  • DISTINCT ON at PostgreSQL
  • ON DUPLICATE KEY UPDATE at MySQL
+3
source

DB2 has a complete Java virtual machine available for server-side processing stored procedures, you do not get much more "complete" than.

CouchDB uses JavaScript; it cannot be more flexible and complete than that.

+1
source

Source: https://habr.com/ru/post/1752461/

More articles:


All Articles