SQL 2008 Optional Feature Compliance

SQL 2008 Optional Feature Compliance

The following table lists the features described in the 2008 SQL standard. Features that are supported in Greenplum Database are marked as YES in the 'Supported' column, features that are not implemented are marked as NO.

For information about Greenplum features and SQL compliance, see the Greenplum Database Administrator Guide.

Table 1. SQL 2008 Optional Feature Compliance Details
ID Feature Supported Comments
B011 Embedded Ada NO  
B012 Embedded C NO Due to issues with PostgreSQL ecpg
B013 Embedded COBOL NO  
B014 Embedded Fortran NO  
B015 Embedded MUMPS NO  
B016 Embedded Pascal NO  
B017 Embedded PL/I NO  
B021 Direct SQL YES  
B031 Basic dynamic SQL NO  
B032 Extended dynamic SQL NO  
B033 Untyped SQL-invoked function arguments NO  
B034 Dynamic specification of cursor attributes NO  
B035 Non-extended descriptor names NO  
B041 Extensions to embedded SQL exception declarations NO  
B051 Enhanced execution rights NO  
B111 Module language Ada NO  
B112 Module language C NO  
B113 Module language COBOL NO  
B114 Module language Fortran NO  
B115 Module language MUMPS NO  
B116 Module language Pascal NO  
B117 Module language PL/I NO  
B121 Routine language Ada NO  
B122 Routine language C NO  
B123 Routine language COBOL NO  
B124 Routine language Fortran NO  
B125 Routine language MUMPS NO  
B126 Routine language Pascal NO  
B127 Routine language PL/I NO  
B128 Routine language SQL NO  
E011 Numeric data types YES  
E011-01 INTEGER and SMALLINT data types YES  
E011-02 DOUBLE PRECISION and FLOAT data types YES  
E011-03 DECIMAL and NUMERIC data types YES  
E011-04 Arithmetic operators YES  
E011-05 Numeric comparison YES  
E011-06 Implicit casting among the numeric data types YES  
E021 Character data types YES  
E021-01 CHARACTER data type YES  
E021-02 CHARACTER VARYING data type YES  
E021-03 Character literals YES  
E021-04 CHARACTER_LENGTH function YES Trims trailing spaces from CHARACTER values before counting
E021-05 OCTET_LENGTH function YES  
E021-06 SUBSTRING function YES  
E021-07 Character concatenation YES  
E021-08 UPPER and LOWER functions YES  
E021-09 TRIM function YES  
E021-10 Implicit casting among the character string types YES  
E021-11 POSITION function YES  
E021-12 Character comparison YES  
E031 Identifiers YES  
E031-01 Delimited identifiers YES  
E031-02 Lower case identifiers YES  
E031-03 Trailing underscore YES  
E051 Basic query specification YES  
E051-01 SELECT DISTINCT YES  
E051-02 GROUP BY clause YES  
E051-03 GROUP BY can contain columns not in SELECT list YES  
E051-04 SELECT list items can be renamed YES  
E051-05 HAVING clause YES  
E051-06 Qualified * in SELECT list YES  
E051-07 Correlation names in the FROM clause YES  
E051-08 Rename columns in the FROM clause YES  
E061 Basic predicates and search conditions YES  
E061-01 Comparison predicate YES  
E061-02 BETWEEN predicate YES  
E061-03 IN predicate with list of values YES  
E061-04 LIKE predicate YES  
E061-05 LIKE predicate ESCAPE clause YES  
E061-06 NULL predicate YES  
E061-07 Quantified comparison predicate YES  
E061-08 EXISTS predicate YES Not all uses work in Greenplum
E061-09 Subqueries in comparison predicate YES  
E061-11 Subqueries in IN predicate YES  
E061-12 Subqueries in quantified comparison predicate YES  
E061-13 Correlated subqueries YES  
E061-14 Search condition YES  
E071 Basic query expressions YES  
E071-01 UNION DISTINCT table operator YES  
E071-02 UNION ALL table operator YES  
E071-03 EXCEPT DISTINCT table operator YES  
E071-05 Columns combined via table operators need not have exactly the same data type YES  
E071-06 Table operators in subqueries YES  
E081 Basic Privileges NO Partial sub-feature support
E081-01 SELECT privilege YES  
E081-02 DELETE privilege YES  
E081-03 INSERT privilege at the table level YES  
E081-04 UPDATE privilege at the table level YES  
E081-05 UPDATE privilege at the column level NO  
E081-06 REFERENCES privilege at the table level NO  
E081-07 REFERENCES privilege at the column level NO  
E081-08 WITH GRANT OPTION YES  
E081-09 USAGE privilege YES  
E081-10 EXECUTE privilege YES  
E091 Set Functions YES  
E091-01 AVG YES  
E091-02 COUNT YES  
E091-03 MAX YES  
E091-04 MIN YES  
E091-05 SUM YES  
E091-06 ALL quantifier YES  
E091-07 DISTINCT quantifier YES  
E101 Basic data manipulation YES  
E101-01 INSERT statement YES  
E101-03 Searched UPDATE statement YES  
E101-04 Searched DELETE statement YES  
E111 Single row SELECT statement YES  
E121 Basic cursor support YES  
E121-01 DECLARE CURSOR YES  
E121-02 ORDER BY columns need not be in select list YES  
E121-03 Value expressions in ORDER BY clause YES  
E121-04 OPEN statement YES  
E121-06 Positioned UPDATE statement NO  
E121-07 Positioned DELETE statement NO  
E121-08 CLOSE statement YES  
E121-10 FETCH statement implicit NEXT YES  
E121-17 WITH HOLD cursors YES  
E131 Null value support YES  
E141 Basic integrity constraints YES  
E141-01 NOT NULL constraints YES  
E141-02 UNIQUE constraints of NOT NULL columns YES Must be the same as or a superset of the Greenplum distribution key
E141-03 PRIMARY KEY constraints YES Must be the same as or a superset of the Greenplum distribution key
E141-04 Basic FOREIGN KEY constraint with the NO ACTION default for both referential delete action and referential update action NO  
E141-06 CHECK constraints YES  
E141-07 Column defaults YES  
E141-08 NOT NULL inferred on PRIMARY KEY YES  
E141-10 Names in a foreign key can be specified in any order YES Foreign keys can be declared but are not enforced in Greenplum
E151 Transaction support YES  
E151-01 COMMIT statement YES  
E151-02 ROLLBACK statement YES  
E152 Basic SET TRANSACTION statement YES  
E152-01 ISOLATION LEVEL SERIALIZABLE clause YES  
E152-02 READ ONLY and READ WRITE clauses YES  
E153 Updatable queries with subqueries NO  
E161 SQL comments using leading double minus YES  
E171 SQLSTATE support YES  
E182 Module language NO  
F021 Basic information schema YES  
F021-01 COLUMNS view YES  
F021-02 TABLES view YES  
F021-03 VIEWS view YES  
F021-04 TABLE_CONSTRAINTS view YES  
F021-05 REFERENTIAL_CONSTRAINTS view YES  
F021-06 CHECK_CONSTRAINTS view YES  
F031 Basic schema manipulation YES  
F031-01 CREATE TABLE statement to create persistent base tables YES  
F031-02 CREATE VIEW statement YES  
F031-03 GRANT statement YES  
F031-04 ALTER TABLE statement: ADD COLUMN clause YES  
F031-13 DROP TABLE statement: RESTRICT clause YES  
F031-16 DROP VIEW statement: RESTRICT clause YES  
F031-19 REVOKE statement: RESTRICT clause YES  
F032 CASCADE drop behavior YES  
F033 ALTER TABLE statement: DROP COLUMN clause YES  
F034 Extended REVOKE statement YES  
F034-01 REVOKE statement performed by other than the owner of a schema object YES  
F034-02 REVOKE statement: GRANT OPTION FOR clause YES  
F034-03 REVOKE statement to revoke a privilege that the grantee has WITH GRANT OPTION YES  
F041 Basic joined table YES  
F041-01 Inner join (but not necessarily the INNER keyword) YES  
F041-02 INNER keyword YES  
F041-03 LEFT OUTER JOIN YES  
F041-04 RIGHT OUTER JOIN YES  
F041-05 Outer joins can be nested YES  
F041-07 The inner table in a left or right outer join can also be used in an inner join YES  
F041-08 All comparison operators are supported (rather than just =) YES  
F051 Basic date and time YES  
F051-01 DATE data type (including support of DATE literal) YES  
F051-02 TIME data type (including support of TIME literal) with fractional seconds precision of at least 0 YES  
F051-03 TIMESTAMP data type (including support of TIMESTAMP literal) with fractional seconds precision of at least 0 and 6 YES  
F051-04 Comparison predicate on DATE, TIME, and TIMESTAMP data types YES  
F051-05 Explicit CAST between datetime types and character string types YES  
F051-06 CURRENT_DATE YES  
F051-07 LOCALTIME YES  
F051-08 LOCALTIMESTAMP YES  
F052 Intervals and datetime arithmetic YES  
F053 OVERLAPS predicate YES  
F081 UNION and EXCEPT in views YES  
F111 Isolation levels other than SERIALIZABLE YES  
F111-01 READ UNCOMMITTED isolation level NO Can be declared but is treated as a synonym for READ COMMITTED
F111-02 READ COMMITTED isolation level YES  
F111-03 REPEATABLE READ isolation level NO Use SERIALIZABLE
F121 Basic diagnostics management NO  
F122 Enhanced diagnostics management NO  
F123 All diagnostics NO  
F131- Grouped operations YES  
F131-01 WHERE, GROUP BY, and HAVING clauses supported in queries with grouped views YES  
F131-02 Multiple tables supported in queries with grouped views YES  
F131-03 Set functions supported in queries with grouped views YES  
F131-04 Subqueries with GROUP BY and HAVING clauses and grouped views YES  
F131-05 Single row SELECT with GROUP BY and HAVING clauses and grouped views YES  
F171 Multiple schemas per user YES  
F181 Multiple module support NO  
F191 Referential delete actions NO  
F200 TRUNCATE TABLE statement YES  
F201 CAST function YES  
F202 TRUNCATE TABLE: identity column restart option NO  
F221 Explicit defaults YES  
F222 INSERT statement: DEFAULT VALUES clause YES  
F231 Privilege tables YES  
F231-01 TABLE_PRIVILEGES view YES  
F231-02 COLUMN_PRIVILEGES view YES  
F231-03 USAGE_PRIVILEGES view YES  
F251 Domain support    
F261 CASE expression YES  
F261-01 Simple CASE YES  
F261-02 Searched CASE YES  
F261-03 NULLIF YES  
F261-04 COALESCE YES  
F262 Extended CASE expression NO  
F263 Comma-separated predicates in simple CASE expression NO  
F271 Compound character literals YES  
F281 LIKE enhancements YES  
F291 UNIQUE predicate NO  
F301 CORRESPONDING in query expressions NO  
F302 INTERSECT table operator YES  
F302-01 INTERSECT DISTINCT table operator YES  
F302-02 INTERSECT ALL table operator YES  
F304 EXCEPT ALL table operator    
F311 Schema definition statement YES Partial sub-feature support
F311-01 CREATE SCHEMA YES  
F311-02 CREATE TABLE for persistent base tables YES  
F311-03 CREATE VIEW YES  
F311-04 CREATE VIEW: WITH CHECK OPTION NO  
F311-05 GRANT statement YES  
F312 MERGE statement NO  
F313 Enhanced MERGE statement NO  
F321 User authorization YES  
F341 Usage Tables NO  
F361 Subprogram support YES  
F381 Extended schema manipulation YES  
F381-01 ALTER TABLE statement: ALTER COLUMN clause   Some limitations on altering distribution key columns
F381-02 ALTER TABLE statement: ADD CONSTRAINT clause    
F381-03 ALTER TABLE statement: DROP CONSTRAINT clause    
F382 Alter column data type YES Some limitations on altering distribution key columns
F391 Long identifiers YES  
F392 Unicode escapes in identifiers NO  
F393 Unicode escapes in literals NO  
F394 Optional normal form specification NO  
F401 Extended joined table YES  
F401-01 NATURAL JOIN YES  
F401-02 FULL OUTER JOIN YES  
F401-04 CROSS JOIN YES  
F402 Named column joins for LOBs, arrays, and multisets NO  
F403 Partitioned joined tables NO  
F411 Time zone specification YES Differences regarding literal interpretation
F421 National character YES  
F431 Read-only scrollable cursors YES Forward scrolling only
01 FETCH with explicit NEXT YES  
02 FETCH FIRST NO  
03 FETCH LAST YES  
04 FETCH PRIOR NO  
05 FETCH ABSOLUTE NO  
06 FETCH RELATIVE NO  
F441 Extended set function support YES  
F442 Mixed column references in set functions YES  
F451 Character set definition NO  
F461 Named character sets NO  
F471 Scalar subquery values YES  
F481 Expanded NULL predicate YES  
F491 Constraint management YES  
F501 Features and conformance views YES  
F501-01 SQL_FEATURES view YES  
F501-02 SQL_SIZING view YES  
F501-03 SQL_LANGUAGES view YES  
F502 Enhanced documentation tables YES  
F502-01 SQL_SIZING_PROFILES view YES  
F502-02 SQL_IMPLEMENTATION_INFO view YES  
F502-03 SQL_PACKAGES view YES  
F521 Assertions NO  
F531 Temporary tables YES Non-standard form
F555 Enhanced seconds precision YES  
F561 Full value expressions YES  
F571 Truth value tests YES  
F591 Derived tables YES  
F611 Indicator data types YES  
F641 Row and table constructors NO  
F651 Catalog name qualifiers YES  
F661 Simple tables NO  
F671 Subqueries in CHECK NO Intentionally ommitted
F672 Retrospective check constraints YES  
F690 Collation support NO  
F692 Enhanced collation support NO  
F693 SQL-session and client module collations NO  
F695 Translation support NO  
F696 Additional translation documentation NO  
F701 Referential update actions NO  
F711 ALTER domain YES  
F721 Deferrable constraints NO  
F731 INSERT column privileges NO  
F741 Referential MATCH types NO No partial match
F751 View CHECK enhancements NO  
F761 Session management YES  
F762 CURRENT_CATALOG NO  
F763 CURRENT_SCHEMA NO  
F771 Connection management YES  
F781 Self-referencing operations YES  
F791 Insensitive cursors YES  
F801 Full set function YES  
F812 Basic flagging NO  
F813 Extended flagging NO  
F831 Full cursor update NO  
F841 LIKE_REGEX predicate NO Non-standard syntax for regex
F842 OCCURENCES_REGEX function NO  
F843 POSITION_REGEX function NO  
F844 SUBSTRING_REGEX function NO  
F845 TRANSLATE_REGEX function NO  
F846 Octet support in regular expression operators NO  
F847 Nonconstant regular expressions NO  
F850 Top-level ORDER BY clause in query expression YES  
F851 Top-level ORDER BY clause in subqueries NO  
F852 Top-level ORDER BY clause in views NO  
F855 Nested ORDER BY clause in query expression NO  
F856 Nested FETCH FIRST clause in query expression NO  
F857 Top-level FETCH FIRST clause in query expression NO  
F858 FETCH FIRST clause in subqueries NO  
F859 Top-level FETCH FIRST clause in views NO  
F860 FETCH FIRST ROWcount in FETCH FIRST clause NO  
F861 Top-level RESULT OFFSET clause in query expression NO  
F862 RESULT OFFSET clause in subqueries NO  
F863 Nested RESULT OFFSET clause in query expression NO  
F864 Top-level RESULT OFFSET clause in views NO  
F865 OFFSET ROWcount in RESULT OFFSET clause NO  
S011 Distinct data types NO  
S023 Basic structured types NO  
S024 Enhanced structured types NO  
S025 Final structured types NO  
S026 Self-referencing structured types NO  
S027 Create method by specific method name NO  
S028 Permutable UDT options list NO  
S041 Basic reference types NO  
S043 Enhanced reference types NO  
S051 Create table of type NO  
S071 SQL paths in function and type name resolution YES  
S091 Basic array support NO Greenplum has arrays, but is not fully standards compliant
S091-01 Arrays of built-in data types NO Partially compliant
S091-02 Arrays of distinct types NO  
S091-03 Array expressions NO  
S092 Arrays of user-defined types NO  
S094 Arrays of reference types NO  
S095 Array constructors by query NO  
S096 Optional array bounds NO  
S097 Array element assignment NO  
S098 ARRAY_AGG Partially Supported: Using array_agg without a window specification; for example

SELECT array_agg(x) FROM ...

SELECT array_agg (x order by y) FROM ...

Not supported: Using array_agg as an aggregate derived window function; for example

SELECT array_agg(x) over (ORDER BY y) FROM ...

SELECT array_agg(x order by y) over (PARTITION BY z) FROM ...

SELECT array_agg(x order by y) over (ORDER BY z) FROM ...

S111 ONLY in query expressions YES  
S151 Type predicate NO  
S161 Subtype treatment NO  
S162 Subtype treatment for references NO  
S201 SQL-invoked routines on arrays NO Functions can be passed Greenplum array types
S202 SQL-invoked routines on multisets NO  
S211 User-defined cast functions YES  
S231 Structured type locators NO  
S232 Array locators NO  
S233 Multiset locators NO  
S241 Transform functions NO  
S242 Alter transform statement NO  
S251 User-defined orderings NO  
S261 Specific type method NO  
S271 Basic multiset support NO  
S272 Multisets of user-defined types NO  
S274 Multisets of reference types NO  
S275 Advanced multiset support NO  
S281 Nested collection types NO  
S291 Unique constraint on entire row NO  
S301 Enhanced UNNEST NO  
S401 Distinct types based on array types NO  
S402 Distinct types based on distinct types NO  
S403 MAX_CARDINALITY NO  
S404 TRIM_ARRAY NO  
T011 Timestamp in Information Schema NO  
T021 BINARY and VARBINARY data types NO  
T022 Advanced support for BINARY and VARBINARY data types NO  
T023 Compound binary literal NO  
T024 Spaces in binary literals NO  
T031 BOOLEAN data type YES  
T041 Basic LOB data type support NO  
T042 Extended LOB data type support NO  
T043 Multiplier T NO  
T044 Multiplier P NO  
T051 Row types NO  
T052 MAX and MIN for row types NO  
T053 Explicit aliases for all-fields reference NO  
T061 UCS support NO  
T071 BIGINT data type YES  
T101 Enhanced nullability determiniation NO  
T111 Updatable joins, unions, and columns NO  
T121 WITH (excluding RECURSIVE) in query expression NO  
T122 WITH (excluding RECURSIVE) in subquery NO  
T131 Recursive query NO  
T132 Recursive query in subquery NO  
T141 SIMILAR predicate YES  
T151 DISTINCT predicate YES  
T152 DISTINCT predicate with negation NO  
T171 LIKE clause in table definition YES  
T172 AS subquery clause in table definition YES  
T173 Extended LIKE clause in table definition YES  
T174 Identity columns NO  
T175 Generated columns NO  
T176 Sequence generator support NO  
T177 Sequence generator support: simple restart option NO  
T178 Identity columns: simple restart option NO  
T191 Referential action RESTRICT NO  
T201 Comparable data types for referential constraints NO  
T211 Basic trigger capability NO  
T211-01 Triggers activated on UPDATE, INSERT, or DELETE of one base table NO  
T211-02 BEFORE triggers NO  
T211-03 AFTER triggers NO  
T211-04 FOR EACH ROW triggers NO  
T211-05 Ability to specify a search condition that must be true before the trigger is invoked NO  
T211-06 Support for run-time rules for the interaction of triggers and constraints NO  
T211-07 TRIGGER privilege YES  
T211-08 Multiple triggers for the same event are executed in the order in which they were created in the catalog NO Intentionally omitted
T212 Enhanced trigger capability NO  
T213 INSTEAD OF triggers NO  
T231 Sensitive cursors YES  
T241 START TRANSACTION statement YES  
T251 SET TRANSACTION statement: LOCAL option NO  
T261 Chained transactions NO  
T271 Savepoints YES  
T272 Enhanced savepoint management NO  
T281 SELECT privilege with column granularity NO  
T285 Enhanced derived column names NO  
T301 Functional dependencies NO  
T312 OVERLAY function YES  
T321 Basic SQL-invoked routines NO Partial support
T321-01 User-defined functions with no overloading YES  
T321-02 User-defined stored procedures with no overloading NO  
T321-03 Function invocation YES  
T321-04 CALL statement NO  
T321-05 RETURN statement NO  
T321-06 ROUTINES view YES  
T321-07 PARAMETERS view YES  
T322 Overloading of SQL-invoked functions and procedures YES  
T323 Explicit security for external routines YES  
T324 Explicit security for SQL routines NO  
T325 Qualified SQL parameter references NO  
T326 Table functions NO  
T331 Basic roles NO  
T332 Extended roles NO  
T351 Bracketed SQL comments (/*...*/ comments) YES  
T431 Extended grouping capabilities NO  
T432 Nested and concatenated GROUPING SETS NO  
T433 Multiargument GROUPING function NO  
T434 GROUP BY DISTINCT NO  
T441 ABS and MOD functions YES  
T461 Symmetric BETWEEN predicate YES  
T471 Result sets return value NO  
T491 LATERAL derived table NO  
T501 Enhanced EXISTS predicate NO  
T511 Transaction counts NO  
T541 Updatable table references NO  
T561 Holdable locators NO  
T571 Array-returning external SQL-invoked functions NO  
T572 Multiset-returning external SQL-invoked functions NO  
T581 Regular expression substring function YES  
T591 UNIQUE constraints of possibly null columns YES  
T601 Local cursor references NO  
T611 Elementary OLAP operations YES  
T612 Advanced OLAP operations NO Partially supported
T613 Sampling NO  
T614 NTILE function YES  
T615 LEAD and LAG functions YES  
T616 Null treatment option for LEAD and LAG functions NO  
T617 FIRST_VALUE and LAST_VALUE function YES  
T618 NTH_VALUE NO Function exists in Greenplum but not all options are supported
T621 Enhanced numeric functions YES  
T631 N predicate with one list element NO  
T641 Multiple column assignment NO Some syntax variants supported
T651 SQL-schema statements in SQL routines NO  
T652 SQL-dynamic statements in SQL routines NO  
T653 SQL-schema statements in external routines NO  
T654 SQL-dynamic statements in external routines NO  
T655 Cyclically dependent routines NO  
M001 Datalinks NO  
M002 Datalinks via SQL/CLI NO  
M003 Datalinks via Embedded SQL NO  
M004 Foreign data support NO  
M005 Foreign schema support NO  
M006 GetSQLString routine NO  
M007 TransmitRequest NO  
M009 GetOpts and GetStatistics routines NO  
M010 Foreign data wrapper support NO  
M011 Datalinks via Ada NO  
M012 Datalinks via C NO  
M013 Datalinks via COBOL NO  
M014 Datalinks via Fortran NO  
M015 Datalinks via M NO  
M016 Datalinks via Pascal NO  
M017 Datalinks via PL/I NO  
M018 Foreign data wrapper interface routines in Ada NO  
M019 Foreign data wrapper interface routines in C NO  
M020 Foreign data wrapper interface routines in COBOL NO  
M021 Foreign data wrapper interface routines in Fortran NO  
M022 Foreign data wrapper interface routines in MUMPS NO  
M023 Foreign data wrapper interface routines in Pascal NO  
M024 Foreign data wrapper interface routines in PL/I NO  
M030 SQL-server foreign data support NO  
M031 Foreign data wrapper general routines NO  
X010 XML type YES  
X011 Arrays of XML type YES  
X012 Multisets of XML type NO  
X013 Distinct types of XML type NO  
X014 Attributes of XML type NO  
X015 Fields of XML type NO  
X016 Persistent XML values YES  
X020 XMLConcat YES xmlconcat2() supported
X025 XMLCast NO  
X030 XMLDocument NO  
X031 XMLElement YES  
X032 XMLForest YES  
X034 XMLAgg YES  
X035 XMLAgg: ORDER BY option YES  
X036 XMLComment YES  
X037 XMLPI YES  
X038 XMLText NO  
X040 Basic table mapping NO  
X041 Basic table mapping: nulls absent NO  
X042 Basic table mapping: null as nil NO  
X043 Basic table mapping: table as forest NO  
X044 Basic table mapping: table as element NO  
X045 Basic table mapping: with target namespace NO  
X046 Basic table mapping: data mapping NO  
X047 Basic table mapping: metadata mapping NO  
X048 Basic table mapping: base64 encoding of binary strings NO  
X049 Basic table mapping: hex encoding of binary strings NO  
X051 Advanced table mapping: nulls absent NO  
X052 Advanced table mapping: null as nil NO  
X053 Advanced table mapping: table as forest NO  
X054 Advanced table mapping: table as element NO  
X055 Advanced table mapping: target namespace NO  
X056 Advanced table mapping: data mapping NO  
X057 Advanced table mapping: metadata mapping NO  
X058 Advanced table mapping: base64 encoding of binary strings NO  
X059 Advanced table mapping: hex encoding of binary strings NO  
X060 XMLParse: Character string input and CONTENT option YES  
X061 XMLParse: Character string input and DOCUMENT option YES  
X065 XMLParse: BLOB input and CONTENT option NO  
X066 XMLParse: BLOB input and DOCUMENT option NO  
X068 XMLSerialize: BOM NO  
X069 XMLSerialize: INDENT NO  
X070 XMLSerialize: Character string serialization and CONTENT option YES  
X071 XMLSerialize: Character string serialization and DOCUMENT option YES  
X072 XMLSerialize: Character string serialization YES  
X073 XMLSerialize: BLOB serialization and CONTENT option NO  
X074 XMLSerialize: BLOB serialization and DOCUMENT option NO  
X075 XMLSerialize: BLOB serialization NO  
X076 XMLSerialize: VERSION NO  
X077 XMLSerialize: explicit ENCODING option NO  
X078 XMLSerialize: explicit XML declaration NO  
X080 Namespaces in XML publishing NO  
X081 Query-level XML namespace declarations NO  
X082 XML namespace declarations in DML NO  
X083 XML namespace declarations in DDL NO  
X084 XML namespace declarations in compound statements NO  
X085 Predefined namespace prefixes NO  
X086 XML namespace declarations in XMLTable NO  
X090 XML document predicate NO xml_is_well_formed_document() supported
X091 XML content predicate NO xml_is_well_formed_content() supported
X096 XMLExists NO xmlexists() supported
X100 Host language support for XML: CONTENT option NO  
X101 Host language support for XML: DOCUMENT option NO  
X110 Host language support for XML: VARCHAR mapping NO  
X111 Host language support for XML: CLOB mapping NO  
X112 Host language support for XML: BLOB mapping NO  
X113 Host language support for XML: STRIP WHITESPACE option YES  
X114 Host language support for XML: PRESERVE WHITESPACE option YES  
X120 XML parameters in SQL routines YES  
X121 XML parameters in external routines YES  
X131 Query-level XMLBINARY clause NO  
X132 XMLBINARY clause in DML NO  
X133 XMLBINARY clause in DDL NO  
X134 XMLBINARY clause in compound statements NO  
X135 XMLBINARY clause in subqueries NO  
X141 IS VALID predicate: data-driven case NO  
X142 IS VALID predicate: ACCORDING TO clause NO  
X143 IS VALID predicate: ELEMENT clause NO  
X144 IS VALID predicate: schema location NO  
X145 IS VALID predicate outside check constraints NO  
X151 IS VALID predicate with DOCUMENT option NO  
X152 IS VALID predicate with CONTENT option NO  
X153 IS VALID predicate with SEQUENCE option NO  
X155 IS VALID predicate: NAMESPACE without ELEMENT clause NO  
X157 IS VALID predicate: NO NAMESPACE with ELEMENT clause NO  
X160 Basic Information Schema for registered XML Schemas NO  
X161 Advanced Information Schema for registered XML Schemas NO  
X170 XML null handling options NO  
X171 NIL ON NO CONTENT option NO  
X181 XML( DOCUMENT (UNTYPED)) type NO  
X182 XML( DOCUMENT (ANY)) type NO  
X190 XML( SEQUENCE) type NO  
X191 XML( DOCUMENT (XMLSCHEMA )) type NO  
X192 XML( CONTENT (XMLSCHEMA)) type NO  
X200 XMLQuery NO  
X201 XMLQuery: RETURNING CONTENT NO  
X202 XMLQuery: RETURNING SEQUENCE NO  
X203 XMLQuery: passing a context item NO  
X204 XMLQuery: initializing an XQuery variable NO  
X205 XMLQuery: EMPTY ON EMPTY option NO  
X206 XMLQuery: NULL ON EMPTY option NO  
X211 XML 1.1 support NO  
X221 XML passing mechanism BY VALUE NO  
X222 XML passing mechanism BY REF NO  
X231 XML( CONTENT (UNTYPED )) type NO  
X232 XML( CONTENT (ANY )) type NO  
X241 RETURNING CONTENT in XML publishing NO  
X242 RETURNING SEQUENCE in XML publishing NO  
X251 Persistent XML values of XML( DOCUMENT (UNTYPED )) type NO  
X252 Persistent XML values of XML( DOCUMENT (ANY)) type NO  
X253 Persistent XML values of XML( CONTENT (UNTYPED)) type NO  
X254 Persistent XML values of XML( CONTENT (ANY)) type NO  
X255 Persistent XML values of XML( SEQUENCE) type NO  
X256 Persistent XML values of XML( DOCUMENT (XMLSCHEMA)) type NO  
X257 Persistent XML values of XML( CONTENT (XMLSCHEMA ) type NO  
X260 XML type: ELEMENT clause NO  
X261 XML type: NAMESPACE without ELEMENT clause NO  
X263 XML type: NO NAMESPACE with ELEMENT clause NO  
X264 XML type: schema location NO  
X271 XMLValidate: data-driven case NO  
X272 XMLValidate: ACCORDING TO clause NO  
X273 XMLValidate: ELEMENT clause NO  
X274 XMLValidate: schema location NO  
X281 XMLValidate: with DOCUMENT option NO  
X282 XMLValidate with CONTENT option NO  
X283 XMLValidate with SEQUENCE option NO  
X284 XMLValidate NAMESPACE without ELEMENT clause NO  
X286 XMLValidate: NO NAMESPACE with ELEMENT clause NO  
X300 XMLTable NO  
X301 XMLTable: derived column list option NO  
X302 XMLTable: ordinality column option NO  
X303 XMLTable: column default option NO  
X304 XMLTable: passing a context item NO  
X305 XMLTable: initializing an XQuery variable NO  
X400 Name and identifier mapping NO