| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: SQL2
>Dear All,
>
>My name is Nadeem Saleemi and I am a new member to the list - just thought
>that I would introduce myself.
>
>I have a couple of SQL-related questions that I would be very grateful if
>anyone could answer them:
>1. I understand that Oracle complies to the SQL2 standard roughly to level 1 -
>Can anyone clarify this?
The ansi/iso sql92 standard has three levels (with increasing functionality):
entry SQL, intermediate SQL and full SQL.
Oracle7 Release 7.1 (and upwards) is fully (not roughly) compliant with the
entry level
of the ansi/iso sql92 standard.
>2. Is there anything out there that fully complies with the SQL2 standard?
Not to my knowledge. Intermediate SQL holds features such as: dynamic sql
(oracle7 has a
form of this), domain support and enhanced transaction semantics.
Full SQL holds features such as: more orthogonality in SQL (eg. subqueries
in check-clauses),
deferred constraint checking, cascade update and scroll cursors.
>3. Where do I find out more about tools-compliance with SQL2?
The standard documentation of Oracle7 tells you how compliant Oracle7 is,
other dbms's
documantion will probably do so too. There is a nice book on the SQL92
standard which
might be interesting to you: 'Understanding the new SQL: a complete guide'
by Jim Melton
and Alan R. Simon.
>
>Thanks,
>
>Nadeem Saleemi
>k927471_at_kingston.ac.uk
>
>
+-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-+
| """ | | T/O-O\N Toon Koppelaars | | \ - / E-mail: T.Koppelaars_at_inter.nl.net | | Phone : 00-31-345-630451 |+-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-+ Received on Mon Mar 04 1996 - 15:54:29 CST
 |
 |