| 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: What SQL-92 Syntax does Oracle Support?
There are various levels of sql-92 compliance.
AFAIK and according to NIST (ftp://speckle.ncsl.nist.gov/vpl/html/sql_vpl.htm), no one has tested above entry level. Every vendor supports pieces of the standard above entry level (there are syntactical features of Oracle that are above entry level). Oracle is fully sql-92 entry level compliant.
You may order copies of the SQL-92 specification from ANSI (http://www.ansi.org/cat_top.html). It spells out what syntax is in each level.
To find the SQL-92 syntax we support (as opposed to the syntax we support), the ANSI spec will be the book.
On 2 Jun 1997 00:53:36 GMT, "Enzo Maini" <enmaini_at_pcnet.com> wrote:
>The Oracle Sales Reps like to say that Oracle is SQL-92 compliant. My
>understanding is that Oracle is only SQL-92 Entry Level Compliant. If they
>were SQL-92 Full Compliant the following syntax would have worked from
>SQL*Plus:
>
>SELECT Job =
> CASE
> WHEN EMPNO > 7800 THEN
> "GREATER THAN 7800"
> ELSE
> empno
> END
>FROM emp;
>
>I tried this on Interbase and UniVerse because I know they are Full SQL-92
>Compliant.
>
>Can ANYBODY tell me what SQL-92 keywords Oracle 7.x supports and where in
>the documentation they
>are listed? Is Oracle 8 going to be SQL-92 Full Compliant? Oracle tech
>support was no help.
>
>So much for being standards compliant Larry!
>
>BTW: As an Oracle developer I know I can achieve the same results using
>DECODE. I am developing an application that uses an SQL-92 database and
>Oracle and was trying to avoid being forced to use different syntaxs for
>different databases to achieve the same results.
>
>Thank you in advance for any response you may have,
>
>Enzo Maini
>enmaini_at_pcnet.com
>
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Bethesda MD
http://govt.us.oracle.com/ -- downloadable utilities
 |
 |