| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: ANSI SQL92 question
A copy of this was sent to "Russ McTyre" <rmctyre_at_solutionbuilders.com>
(if that email address didn't require changing)
On Wed, 7 Oct 1998 07:34:08 -0400, you wrote:
>Rob,
>
>Thanks for the response. I know Oracle8 uses the (+) syntax for outer
>joins, but I was wondering if it also supported the ANSI 92 standard join
>syntax. I ask because I'm developing a database application that uses ODBC
>to attach to a myriad of databases, and so far, Oracle is the only one I've
>encountered that doesn't seem to support the ANSI 92 (INNER JOIN, LEFT JOIN,
>RIGHT JOIN, OUTER JOIN) syntax. Are there any settings that control this
>behavior on the server side?
>
>Thanks,
>
>Russ
>
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
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. Received on Wed Oct 07 1998 - 06:46:34 CDT
 |
 |