Conformance with Standard SQL

• American National Standards Institute (ANSI)

• International Standards Organization (ISO)

• United States Federal Government

ANSI and ISO Compliance

American National Standards Institute 1430 Broadway New York, NY 10018 USA

The ANSI and ISO SQL standards require conformance claims to state the type of conformance and the implemented facilities. The Oracle7 Server, the Oracle Precompilers Version 1.5, and SQL*Module Version 1.0 provide conformance with the ANSI X3.135-1992/ISO 9075-1992 standard:

• Compliance at Entry Level (including both SQL-DDL and SQL-DML)

• Module Language

• Embedded SQL Ada

• Embedded SQL C

• Embedded SQL COBOL

• Embedded SQL FORTRAN

• Embedded SQL Pascal

• Embedded SQL PL/I

• Full implementation of the Integrity Enhancement Feature

FIPS Compliance

Section 16.2 Programming Language Interfaces The Oracle Precompilers support the use of Embedded SQL. SQL*Module supports the use of Module Language. Support is provided for Ada, C, COBOL, FORTRAN, and Pascal.

Section 16.3 Style of Language Interface Oracle with SQL*Module supports Module Language for Ada, C, COBOL, FORTRAN, and Pascal. Oracle with the Oracle Precompilers supports Ada, C, COBOL, FORTRAN, and Pascal. The languages supported may vary depending on your operating system.

Section 16.5 Interactive Direct SQL Oracle7 with SQL*Plus Version 3.1 (as well as other Oracle tools) supports "direct invocation" of the following SQL commands, meeting the requirements of FIPS PUB 127-2:

• CREATE TABLE command

• CREATE VIEW command

• GRANT command

• INSERT command

• SELECT command, with ORDER BY clause but not INTO clause

• UPDATE command: searched

• DELETE command: searched

• COMMIT WORK command

• ROLLBACK WORK command

Section 16.6 Sizing for Database Constructs Table 4 - 15 lists requirements identified in FIPS PUB 127-1 and how they are met by Oracle7.

Length of an identifier (in bytes)	18	30
Length of CHARACTER datatype (in bytes)	240	255
Decimal precision of NUMERIC datatype	15	38
Decimal precision of DECIMAL datatype	15	38
Decimal precision of INTEGER datatype	9	38
Decimal precision of SMALLINT datatype	4	38
Binary precision of FLOAT datatype	20	126
Binary precision of REAL datatype	20	63
Binary precision of DOUBLE PRECISION datatype	30	126
Columns in a table	100	254
Values in an INSERT statement	100	254
Set clauses in an UPDATE statement (Note 1)	20	254
Length of a row (Note 2, 3)	2000	2(254) + 231 +253(2000)
Columns in a UNIQUE constraint	6	16
Length of a UNIQUE constraint (Note 2)	120	(Note 4)
Length of foreign key column list (Note 2)	120	(Note 4)
Columns in a GROUP BY clause	6	255 (Note 5)
Sort specifications in ORDER BY clause	6	255 (Note 5)
Columns in a referential integrity constraint	6	16
Tables referenced in a SQL statement	10	No limit
Cursors simultaneously open	10	(Note 6)
Items in a SELECT list	100	255

Table 4 - 15. Sizing for Database Constructs

¹ The number of set clauses in an UPDATE statement refers to the number items separated by commas following the SET keyword.

² The FIPS PUB defines the length of a collection of columns to be the sum of: twice the number of columns, the length of each character column in bytes, decimal precision plus 1 of each exact numeric column, binary precision divided by 4 plus 1 of each approximate numeric column.

³ The Oracle limit for the maximum row length is based on the maximum length of a row containing a LONG value of length 2 gigabytes and 253 VARCHAR2 values, each of length 2000 bytes.

⁴ The Oracle limit for a UNIQUE key is half the size of an Oracle data block (specified by the initialization parameter DB_BLOCK_SIZE) minus some overhead.

⁵ Oracle places no limit on the number of columns in a GROUP BY clause or the number of sort specifications in an ORDER BY clause. However, the sum of the sizes of all the expressions in either a GROUP BY or an ORDER BY clause is limited to the size of an Oracle data block (specified by the initialization parameter DB_BLOCK_SIZE) minus some overhead.

⁶ The Oracle limit for the number of cursors simultaneously opened is specified by the initialization parameter OPEN_CURSORS. The maximum value of this parameter depends on the memory available on your operating system and exceeds 100 in all cases.

Section 16.7 Character Set Support 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 multi-byte character sets.