Re: [Q] Oracle products are not SQL2 conform

Gregoire Duchateau <Gregoire.Duchateau_at_aar.alcatel-alsthom.fr> wrote:
>
>
>
> I recently read in a magazine that
>
> SQL2 -as defined in 1992 by OSI- is composed of 3 levels:
> Entry
> Intermediate
> Full
>
> and that their is currently no oracle product which even comply with level
> "Intermediate". ^^^^^^^^^^^^^^^^^
>
> Is it true? Why?
> Do you have any info (or pointers) about SQL standards and their compliance?
>
> Thanks Greg
>
> -------------------------------------------------------------------------
> Gregoire Duchateau Gregoire.Duchateau_at_aar.alcatel-alsthom.fr
> Alcatel Alsthom Recherche
> Route de Nozay, Tel: 33-1-64.49.14.88
> 91460 Marcoussis, France. Fax: 33-1-64.49.06.95
>

SQL-92 (ISO 9075:1992 and ANS X3.135-1992) does indeed have the three levels described.

And, it is certainly true that no Oracle product has been certified compliant with intermediate SQL-92, although Oracle 7 and Oracle Rdb have tested against entry level SQL-92.

In the U.S., the National Institute of Standards and Testing (NIST) is responsible for testing and certifying compliance. Last I heard, NIST was supposed to start testing for "Early Intermediate" compliance sometime this spring. I haven't heard anything recently about the current status, and the NIST validated processor list (http://speckle.ncsl.nist.gov/vpl/html/sqlintro.htm) does not show anything about intermediate. (Perhaps David Flayter can add to this.)

As far as I know, NIST is the only organization that currently does compliance testing. X/Open (http://www.xopen.org) is supposedly developing a set of test for Late intermediate SQL-92, but I have no information on that status.

Early Intermediate and Late Intermediate are defined in the NIST publication FIPS-127.2. They are subsets of the SQL-92 intermediate level.

Anyhow, for more information on the SQL standard, take a look at the SQL Standards home page at http://www.jcc.com/sql_stnd.html

Keith Hare
JCC Consulting, Inc. (http://www.jcc.com) Member X3H2, the U.S. SQL standards committee Received on Tue May 16 1995 - 00:00:00 CEST