[thesite] sql question..

Dean Mah dsmah at home.com
Mon Jun 11 17:22:16 CDT 2001


rudy writes:

> > ... Oracle ... didn't use the above join syntax
> 
> well, blow me down
> 
> isn't the INNER JOIN .. ON syntax standard sql-92 or something? i am
> shocked
> 
> doesn't oracle claim sql compliance?

Straight from the Oracle SQL Reference:

   SQL-92 defined four levels of compliance: Entry, Transitional,
   Intermediate, and Full. A conforming SQL implementation must
   support at least Entry SQL. Oracle8i fully supports Entry SQL as
   outlined in Federal Information Processing Standard (FIPS) PUB
   127-2, and has many features that conform to Transitional,
   Intermediate, or Full SQL.

So they are as compliant as they need to be.  :)

Dean




More information about the thesite mailing list