Re: Is Oracle SQL99 Compliant?

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 Received on Thu Jan 13 2005 - 16:16:13 CST