Re: ORACLE "SQL-92 compliant" NO WAY

A copy of this was sent to "Guido Le Lorrain" <Guido_at_palmstech.com> (if that email address didn't require changing) On Thu, 15 Oct 1998 18:17:49 -0000, you wrote:

>I don't know if anyone has picked up on this but I confess I have not been
>reading the news groups for a while so sorry if its common knowledge.
>
>Oracle say that they provide "conformance with the ANSI X3.135-1992/ISO
>9075-1992 standard" however, they are wrong!!!!!!!
>
>Their OUTER JOIN syntax is different from everybody else's. So who gave them
>the sticker to say they were?
>
>And guess what, it's NOT fixed in Oracle 8.
>
>
>

No, Oracle supports the *same certified* level of SQL92 as everyone else. Its that the syntax you want to use is designated for a 'higher level' of compliance then any vendor has built their software for.

there are 4 levels of ANSI SQL 92

o entry level -- the only level to which any database vendor has tested to date o intermediate
o transitional
o full

the INNER JOIN, LEFT JOIN, RIGHT JOIN, OUTER JOIN syntax is not part of entry level, the level to which Oracle (and all others) currently comply. Each of us has implemented various syntax features of the higher levels, but no one (AFAIK) has complied with any of the higher levels.

You need to stick with entry level syntax constructs in order to write sql that works on all (and even that won't be 100%).  

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA

--
http://govt.us.oracle.com/    -- downloadable utilities
 
----------------------------------------------------------------------------
Opinions are mine and do not necessarily reflect those of Oracle Corporation
 
Anti-Anti Spam Msg: if you want an answer emailed to you, 
you have to make it easy to get email to you.  Any bounced
email will be treated the same way i treat SPAM-- I delete it.