| 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 "Rob" <rob_at_ohall.com>
(if that email address didn't require changing)
On Wed, 7 Oct 1998 18:39:34 +0200, you wrote:
>Hi Russ,
>as I know Oracle do not support the usuall SQL92 syntax and uses it's own
>extension.
No, Oracle supports the same 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%).
>I think you cannot configure the server to support the normal syntax. ( like
>Adabas does!)
>I am very unhappy about that, and I must use a "translater" when I am
>programming
>portable Database-Java Applications, it's a lot of work.
>But when you attach your application to myriad of databases, you surly agree
>with me, that
>MSAccess is much more incompatible.
>Cheerio
>Rob
>
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 Thu Oct 08 1998 - 11:23:54 CDT
 |
 |