Is Oracle SQL99 Compliant?

On 13 Jan 2005 12:51:28 -0800, seapearl1023@ms65.url.com.tw wrote:

>My question is if Oracle Standard version is SQL99 Compliant? How about
>Oracle Enterprise version?

No, not entirely. (Is any database entirely compliant?)

Oracle 9.2 is considerably closer to compliance compared with previous
versions, however.

--
Andy Hassall / /
Space: disk usage analysis tool

On 13 Jan 2005 12:51:28 -0800, seapearl1023@ms65.url.com.tw wrote:

>My question is if Oracle Standard version is SQL99 Compliant? How about
>Oracle Enterprise version?

No, not entirely. (Is any database entirely compliant?)

Oracle 9.2 is considerably closer to compliance compared with previous
versions, however.

--
Andy Hassall / /
Space: disk usage analysis tool

On 13 Jan 2005 12:51:28 -0800, seapearl1023@ms65.url.com.tw wrote:

>My question is if Oracle Standard version is SQL99 Compliant? How about
>Oracle Enterprise version?

No, not entirely. (Is any database entirely compliant?)

Oracle 9.2 is considerably closer to compliance compared with previous
versions, however.

--
Andy Hassall / /
Space: disk usage analysis tool

On 13 Jan 2005 12:51:28 -0800, seapearl1023@ms65.url.com.tw wrote:

>My question is if Oracle Standard version is SQL99 Compliant? How about
>Oracle Enterprise version?

No, not entirely. (Is any database entirely compliant?)

Oracle 9.2 is considerably closer to compliance compared with previous
versions, however.

--
Andy Hassall / /
Space: disk usage analysis tool

On 13 Jan 2005 12:51:28 -0800, seapearl1023@ms65.url.com.tw wrote:

>My question is if Oracle Standard version is SQL99 Compliant? How about
>Oracle Enterprise version?

No, not entirely. (Is any database entirely compliant?)

Oracle 9.2 is considerably closer to compliance compared with previous
versions, however.

--
Andy Hassall / /
Space: disk usage analysis tool

On 13 Jan 2005 12:51:28 -0800, seapearl1023@ms65.url.com.tw wrote:

>My question is if Oracle Standard version is SQL99 Compliant? How about
>Oracle Enterprise version?

No, not entirely. (Is any database entirely compliant?)

Oracle 9.2 is considerably closer to compliance compared with previous
versions, however.

--
Andy Hassall / /
Space: disk usage analysis tool

On 13 Jan 2005 12:51:28 -0800, seapearl1023@ms65.url.com.tw wrote:

>My question is if Oracle Standard version is SQL99 Compliant? How about
>Oracle Enterprise version?

No, not entirely. (Is any database entirely compliant?)

Oracle 9.2 is considerably closer to compliance compared with previous
versions, however.

--
Andy Hassall / /
Space: disk usage analysis tool

On Thu, 13 Jan 2005 12:51:28 -0800, seapearl1023 wrote:

> Hi,
>
> My question is if Oracle Standard version is SQL99 Compliant? How about
> Oracle Enterprise version?
>

Depends entirely on what you mean by 'compliant'. The standard actually
includes several levels of compliance.

In general, it's pretty close. If you look at the SQL Reference manual
for the version you want, there's an entire section allocated to this.
(This is Appendix B in Oracle9iR2 manuals st http://tahiti.oracle.com!)

BTW: Standard and Enterprise are 'Editions' (effectively feature sets),
not versions. Version is something like '8.1', '9.0', '9.2', '10.1'.
Enterprise is a 100% superset of Standard and uses exacctly the same code
base - AFAIK, the SQL is identical.

Speculation: this kind of question is usually asked by people who want to
write 'database independant' software. If that is true, please consider
reading the first 3 chapters of Thomas Kyte's "Effective Oracle By Design"
to understand why that is a bad idea.

lol/FGB

On Thu, 13 Jan 2005 12:51:28 -0800, seapearl1023 wrote:

> Hi,
>
> My question is if Oracle Standard version is SQL99 Compliant? How about
> Oracle Enterprise version?
>

Depends entirely on what you mean by 'compliant'. The standard actually
includes several levels of compliance.

In general, it's pretty close. If you look at the SQL Reference manual
for the version you want, there's an entire section allocated to this.
(This is Appendix B in Oracle9iR2 manuals st http://tahiti.oracle.com!)

BTW: Standard and Enterprise are 'Editions' (effectively feature sets),
not versions. Version is something like '8.1', '9.0', '9.2', '10.1'.
Enterprise is a 100% superset of Standard and uses exacctly the same code
base - AFAIK, the SQL is identical.

Speculation: this kind of question is usually asked by people who want to
write 'database independant' software. If that is true, please consider
reading the first 3 chapters of Thomas Kyte's "Effective Oracle By Design"
to understand why that is a bad idea.

lol/FGB