| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Anyone with experience with MMOG and databases?
PostgreSQL is not a commercial product. I will not comment on that one; Ingres
used to be quite good in the old days.
About IBM DB2, which DB2 flavor do you mean? it was a brilliant move from IBM
marketing to call all their (mutually nonexchangeable and even non-comparable)
database products "DB2". If you refer to the mainframe product, I sort of agree
-- although even that product lacks some serious stuff. The other products they
call DB2 are inferior to Oracle.
SQL/PSM is *not* part of core SQL -- and I personally think the Oracle proprietary PL/SQL language is much better and more efficient; Oracle is never going to implement SQL/PSM. The other two issues you mention (DATE datatype and CONNECT BY) were implemented many, many years before even the very first and lousy SQL standard (SQL86) was established. Backward compatibility issues make it tough to "fix" such things -- Oracle had a hard time changing the existing CHAR datatype, being *variable* character strings, to a fixed lenght type while introducing VARCHAR[2] to replace the old behavior.
kind regards,
Lex.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On
Behalf Of Leandro Guimaraes Faria C. Dutra
Sent: Friday, August 12, 2005 20:09
To: lex.de.haan_at_naturaljoin.nl
Cc: Oracle-L_at_freelists.org; oracle-l-bounce_at_freelists.org;
Thomas.Mercadante_at_labor.state.ny.us
Subject: RE: Anyone with experience with MMOG and databases?
oracle-l-bounce_at_freelists.org gravou em 2005-08-12 15:00:56:
> ANSI is *not* an old hat -- it is a national hat, just like DIN
I stand correct. I was in error for thinking in the 'popular', but
wrong way, that when people refer to ANSI SQL they are usually thinking pre-ISO
SQL:1999.
> close that they are documented together. And if anyone says that
> Oracle
is far
> away from implementing the ANSI/ISO standard, I challenge that person
> to mention a product that comes closer...
Would you take two? IBM DB2 and PostgreSQL.
Oracle has great coverage of the standards, but even in SQL ISO:1999 it deviated too much in the core. Things like DATE type, CONNECT BY, PL/SQL vs SQL/PSM.
> By the way, I assume we are talking core SQL:2003 if you talk about
> the
SQL
> standard, right? that's the *only* existing standard, because ISO
standards
> supersede eachother.
Yep, great point. But I have to admit I haven't followed up much since ISO SQL:1999, since I dislike the general direction of ISO SQL away from its relational roots.
-- Leandro Guimarães Faria Corcete DUTRA Administrador de Bases de Dados +55 (11) 4390 5383 Toyota do Brasil Ltda ldutra_at_toyota.com.br São Bernardo do Campo, SP BRASIL This message (including any attachments) is confidential and may be privileged and intended solely for the use of the person/entity to whom it is addressed. If you have received it by mistake please notify the sender by returning via e-mail as well as delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is prohibited. Please note that e-mails are susceptible to change. TOYOTA DO BRASIL LTDA (including its group companies) shall not be liable for the improper or incomplete transmission of the information contained in this communication, neither for personal, nonbusiness related information nor opinion sent through this email or even for any delay in its receipt or damage to your system. TOYOTA DO BRASIL LTDA (or its group companies) does not guarantee that the integrity of this communication has been kept nor that this communication is free of viruses, interceptions or interference. -- http://www.freelists.org/webpage/oracle-lReceived on Fri Aug 12 2005 - 13:28:26 CDT
 |
 |