Re: Progress toward SQL-92 ?

secrist_at_kxovax.enet.dec.com (Strong datatypes for weak minds.) writes:

>What progress is Oracle* making toward SQL-92 ? Does Oracle7 deprecate
>any features from Oracle{6,5...} toward the goal of advancing SQL-92 ?
>Is Oracle7 SQL-89 FIPS-n compliant ?
 

>Regards,
>rcs
 

>. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
>Richard C. Secrist "The superior man understands +-+-+-+-+-+-+-+
>Digital Equipment Corp. what is right; the inferior man |d|i|g|i|t|a|l|
>secrist_at_kxovax.enet.dec.com understands what will sell." +-+-+-+-+-+-+-+tm
>. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Oracle7 Server and Trusted Oracle7 have been certified as being compliant with FIPS 127-1. The testing has been done on a number of platforms with initial testing going back to March 1991. This certification includes both the mandatory and optional parts of the FIPS 127-1 tests (optional are referential integrity and semantic checking for FIPS Flagger).

Oracle7 Version 7.1 will fully conform to at least entry level FIPS 127-2 (SQL 92). I don't know if it will fully conform to higher levels of the standard in the initial release.

Oracle has been pretty aggressive in scheduling NIST certification testing in the past and I would expect to see fairly early certification to FIPS 127-2.

Generally, when the traditional Oracle method of performing a function differs from the standard, you are given a choice as to which behaviour you wish to have (i.e. Oracle6 or FIPS 127-1).

Hope this helps.
Dave Dargo (ddargo_at_oracle.com) Received on Wed Aug 25 1993 - 20:11:44 CEST