F844SUBSTRING_REGEX functionNOconsider regexp_substr()

F845TRANSLATE_REGEX functionNOconsider regexp_replace()

F846Octet support in regular expression operatorsNO

F847Nonconstant regular expressionsNO

F850Top-level<order by clause>in<query expression>YES

F851<order by clause> in subqueriesYES

F852Top-level<order by clause> in viewsYES

F855Nested<order by clause>in<query expression>YES

F856Nested<fetch first clause>in<query expression>YES

F857Top-level<fetch first clause>in<query expression>YES

F858<fetch first clause> in subqueriesYES

F859Top-level<fetch first clause> in viewsYES

F847Non-constant regular expressionsNO

F850Top-levelORDER BYin query expressionYES

F851ORDER BY in subqueriesYES

F852Top-levelORDER BY in viewsYES

F855NestedORDER BYin query expressionYES

F856NestedFETCH FIRSTin query expressionYES

F857Top-levelFETCH FIRSTin query expressionYES

F858FETCH FIRST in subqueriesYES

F859Top-levelFETCH FIRST in viewsYES

F860Dynamic FETCH FIRST row countYES

F861Top-level<result offset clause>in<query expression>YES

F862<result offset clause> in subqueriesYES

F863Nested<result offset clause>in<query expression>YES

F864Top-level<result offset clause> in viewsYES

F865<offset row count> in<result offset clause>YES

F861Top-levelOFFSETin query expressionYES

F862OFFSET in subqueriesYES

F863NestedOFFSETin query expressionYES

F864Top-levelOFFSET in viewsYES

F865Dynamicoffset row count inOFFSETYES

F866FETCH FIRST clause: PERCENT optionNO

F867FETCH FIRST clause: WITH TIES optionYES

F868ORDER BY in grouped tableYES

T047POSITION, OCTET_LENGTH, TRIM, and SUBSTRING for BLOBsNO

T048Concatenation of BLOBsNO

T049BLOB locator: non-holdableNO

T050POSITION, CHAR_LENGTH, OCTET_LENGTH, LOWER, TRIM, UPPER, and SUBSTRING CLOBsNO

T050POSITION, CHAR_LENGTH, OCTET_LENGTH, LOWER, TRIM, UPPER, and SUBSTRINGforCLOBsNO

T051Row typesNO

T053Explicit aliases for all-fields referenceNO

T054GREATEST and LEASTYESdifferent null handling

T326Table functionsNO

T331Basic rolesYES

T332Extended rolesYES

T341Overloading of SQL-invoked functions and proceduresYES

T351BracketedSQLcomments (/*...*/ comments)YES

T341Overloading of SQL-invoked functions andSQL-invokedproceduresYES

T351Bracketed commentsYES

T431Extended grouping capabilitiesYES

T432Nested and concatenated GROUPING SETSYES

T433Multiargument GROUPING functionYES

T433Multi-argument GROUPING functionYES

T434GROUP BY DISTINCTYES

T441ABS and MOD functionsYES

T461Symmetric BETWEEN predicateYES

X153IS VALID predicate: with SEQUENCE optionNO

X155IS VALID predicate: NAMESPACE without ELEMENT clauseNO

X157IS VALID predicate: NO NAMESPACE with ELEMENT clauseNO

X160Basic Information Schema for registered XMLSchemasNO

X161Advanced Information Schema for registered XMLSchemasNO

X160Basic Information Schema for registered XMLschemasNO

X161Advanced Information Schema for registered XMLschemasNO

X170XML null handling optionsNO

X171NIL ON NO CONTENT optionNO

X181XML(DOCUMENT(UNTYPED)) typeNO