C Oracle and Standard SQL

This appendix declares Oracle's conformance to the SQL standards established by the American National Standards Institute (ANSI) and the International Organization for Standardization (ISO).

The ISO SQL standard consists of eleven parts (SQL/Framework, SQL/Foundation, SQL/CLI, SQL/PSM, SQL/MED, SQL/OLB, SQL/Schemata, SQL/JRT, SQL/XML, SQL/MDA, and SQL/PGQ). The ANSI SQL standard consists of the same eleven parts.

The mandatory portion of SQL is known as Core SQL and is found in Part 2 (Foundation) and Part 11 (Schemata).

This appendix contains the following sections:

• ANSI Standards

• ISO Standards

• Oracle Compliance to Core SQL

• Oracle Support for Optional Features of SQL/Foundation

• Oracle Compliance with SQL/CLI

• Oracle Compliance with SQL/PSM

• Oracle Compliance with SQL/MED

• Oracle Compliance with SQL/OLB

• Oracle Compliance with SQL/JRT

• Oracle Compliance with SQL/XML

• Oracle Compliance with FIPS 127-2

• Oracle Extensions to Standard SQL

• Oracle Compliance with Older Standards

• Character Set Support