Re: Foreign key in Oracle Sql
Date: 13 Jan 2005 08:03:34 -0800
Message-ID: <1105632214.119446.305100_at_z14g2000cwz.googlegroups.com>
>> On the other side one should acknowledge that not a single major
Ever hear of FIPS-127 Conformance testing? When that was in place,
conformance SQL-92 the direction for all of the vendors in ANSI X3H2.
Then Clinton closed down the program in exchange for a campaign
contribution from a private testing lab and we started to get drift.
Mike Gorman did some articles on this that you can find at his
Whitemarsh Consulting site.
Oracle and IBM pushed the OLAP stuff in SQL-99 together, so that is
showing up in many other products. The definitions favor contigous
sequential storage models, but are not procedrually defined as such.
You might want to look at Yukon, Teradata, CA-Ingres, Pervasive, DB2
and several other smaller players -- all of them do a good job with the
SQL-92 specs and lots of the SQL-99 features. In fact, SQL is probably
one of the most portable languages for having so many implementations
on so many platforms. You can even find SQL dialect translators for
porting your projects.
player in the RDBMS marketplace has actually followed the ANSI
Committee's recommendations. They take what they want and ignore what
they don't. <<