Oracle8i SQL Reference Release 2 (8.1.6) A76989-01 |
|
Oracle and Standard SQL, 2 of 3
This section declares Oracle's conformance to the SQL standards established by these organizations:
Oracle8i complies at the Entry level as defined in the ANSI document, X3.135-1992, "Database Language SQL." You can obtain a copy of the ANSI standard from this address:
The ANSI and ISO SQL standards require conformance claims to state the type of conformance and the implemented facilities. The Oracle server, Oracle Precompilers for C/C++ Release 8.1, Oracle Precompiler for Cobol Release 8.1, and SQL*Module for ADA Release 8.0.4 provide conformance with the ANSI X3.135-1992/ISO 9075-1992 standard:
In addition to full compliance at the Entry level, Oracle complies partially at the Transitional, Intermediate, and Full levels as described in Table B-1 (including both SQL-DDL and SQL-DML).
Oracle complies completely with FIPS PUB 127-2 for Entry SQL. In addition, the following information is provided for Section 16, "Special Procurement Considerations."
The Oracle precompilers support the use of embedded SQL in C and COBOL. SQL*Module supports the use of Module Language in ADA.
Oracle with SQL*Module supports Module Language for Ada. Oracle with the Oracle precompilers supports C and COBOL. The specific languages supported depend on your operating system.
Oracle8i with SQL*Plus Version 3.1 (as well as other Oracle tools) supports "direct invocation" of the following SQL statements, meeting the requirements of FIPS PUB 127-2:
CREATE TABLE
statement
CREATE VIEW
statement
GRANT
statement
INSERT
statement
SELECT
statement, with ORDER BY
clause but not INTO
clause
UPDATE
statement: searched
DELETE
statement: searched
COMMIT WORK
statement
ROLLBACK WORK
statement
Most other SQL statements described in this reference are also supported interactively.
Table B-2 lists requirements identified in FIPS PUB 127-1 and how they are met by Oracle8i.
Oracle supports the ASCII character set (FIPS PUB 1-2) on most computers and the EBCDIC character set on IBM mainframe computers. Oracle supports both single-byte and multibyte character sets.
|
![]() Copyright © 1999 Oracle Corporation. All Rights Reserved. |
|