C Oracle and Standard SQL

This appendix discusses Oracle's conformance with the SQL:2008, SQL:2011 and SQL:2012 standards. Note that the SQL standard consists of ten parts; one part (SQL/RPR:2012) is new in 2102; five other parts were revised in 2011; for the other four parts, the 2008 version remains in place.

The mandatory portion of SQL:2011 is known as Core SQL:2011 and is found in SQL:2011 Part 2 (Foundation) and Part 11 (Schemata). The Foundation features are analyzed in Annex F of Part 2 in the table "Feature taxonomy and definition for mandatory features of SQL/Foundation". The Schemata features are analyzed in Annex E of Part 11 in the table "Feature taxonomy and definition for mandatory features of SQL/Schemata". There is no mandatory portion of SQL:2008 that has not been superseded by SQL:2011. There is no mandatory portion of SQL/RPR:2012.

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). SQL/RPR:2012 is ANSI-only; otherwise the ANSI and ISO SQL standards are identical.

This appendix contains the following sections: