B012 Embedded C B021 Direct SQL E011 Core Numeric data types E011-01 Core INTEGER and SMALLINT data types E011-02 Core REAL, DOUBLE PRECISION, and FLOAT data types E011-03 Core DECIMAL and NUMERIC data types E011-04 Core Arithmetic operators E011-05 Core Numeric comparison E011-06 Core Implicit casting among the numeric data types E021 Core Character data types E021-01 Core CHARACTER data type E021-02 Core CHARACTER VARYING data type E021-03 Core Character literals E021-04 Core CHARACTER_LENGTH function trims trailing spaces from CHARACTER values before counting E021-05 Core OCTET_LENGTH function E021-06 Core SUBSTRING function E021-07 Core Character concatenation E021-08 Core UPPER and LOWER functions E021-09 Core TRIM function E021-10 Core Implicit casting among the character string types E021-11 Core POSITION function E021-12 Core Character comparison E031 Core Identifiers E031-01 Core Delimited identifiers E031-02 Core Lower case identifiers E031-03 Core Trailing underscore E051 Core Basic query specification E051-01 Core SELECT DISTINCT E051-02 Core GROUP BY clause E051-04 Core GROUP BY can contain columns not in <select list> E051-05 Core Select list items can be renamed E051-06 Core HAVING clause E051-07 Core Qualified * in select list E051-08 Core Correlation names in the FROM clause E051-09 Core Rename columns in the FROM clause E061 Core Basic predicates and search conditions E061-01 Core Comparison predicate E061-02 Core BETWEEN predicate E061-03 Core IN predicate with list of values E061-04 Core LIKE predicate E061-05 Core LIKE predicate ESCAPE clause E061-06 Core NULL predicate E061-07 Core Quantified comparison predicate E061-08 Core EXISTS predicate E061-09 Core Subqueries in comparison predicate E061-11 Core Subqueries in IN predicate E061-12 Core Subqueries in quantified comparison predicate E061-13 Core Correlated subqueries E061-14 Core Search condition E071 Core Basic query expressions E071-01 Core UNION DISTINCT table operator E071-02 Core UNION ALL table operator E071-03 Core EXCEPT DISTINCT table operator E071-05 Core Columns combined via table operators need not have exactly the same data type E071-06 Core Table operators in subqueries E081 Core Basic Privileges E081-01 Core SELECT privilege E081-02 Core DELETE privilege E081-03 Core INSERT privilege at the table level E081-04 Core UPDATE privilege at the table level E081-05 Core UPDATE privilege at the column level E081-06 Core REFERENCES privilege at the table level E081-07 Core REFERENCES privilege at the column level E081-08 Core WITH GRANT OPTION E081-09 Core USAGE privilege E081-10 Core EXECUTE privilege E091 Core Set functions E091-01 Core AVG E091-02 Core COUNT E091-03 Core MAX E091-04 Core MIN E091-05 Core SUM E091-06 Core ALL quantifier E091-07 Core DISTINCT quantifier E101 Core Basic data manipulation E101-01 Core INSERT statement E101-03 Core Searched UPDATE statement E101-04 Core Searched DELETE statement E111 Core Single row SELECT statement E121 Core Basic cursor support E121-01 Core DECLARE CURSOR E121-02 Core ORDER BY columns need not be in select list E121-03 Core Value expressions in ORDER BY clause E121-04 Core OPEN statement E121-06 Core Positioned UPDATE statement E121-07 Core Positioned DELETE statement E121-08 Core CLOSE statement E121-10 Core FETCH statement implicit NEXT E121-17 Core WITH HOLD cursors E131 Core Null value support (nulls in lieu of values) E141 Core Basic integrity constraints E141-01 Core NOT NULL constraints E141-02 Core UNIQUE constraints of NOT NULL columns E141-03 Core PRIMARY KEY constraints E141-04 Core Basic FOREIGN KEY constraint with the NO ACTION default for both referential delete action and referential update action E141-06 Core CHECK constraints E141-07 Core Column defaults E141-08 Core NOT NULL inferred on PRIMARY KEY E141-10 Core Names in a foreign key can be specified in any order E151 Core Transaction support E151-01 Core COMMIT statement E151-02 Core ROLLBACK statement E152 Core Basic SET TRANSACTION statement E152-01 Core SET TRANSACTION statement: ISOLATION LEVEL SERIALIZABLE clause E152-02 Core SET TRANSACTION statement: READ ONLY and READ WRITE clauses E153 Core Updatable queries with subqueries E161 Core SQL comments using leading double minus E171 Core SQLSTATE support F021 Core Basic information schema F021-01 Core COLUMNS view F021-02 Core TABLES view F021-03 Core VIEWS view F021-04 Core TABLE_CONSTRAINTS view F021-05 Core REFERENTIAL_CONSTRAINTS view F021-06 Core CHECK_CONSTRAINTS view F031 Core Basic schema manipulation F031-01 Core CREATE TABLE statement to create persistent base tables F031-02 Core CREATE VIEW statement F031-03 Core GRANT statement F031-04 Core ALTER TABLE statement: ADD COLUMN clause F031-13 Core DROP TABLE statement: RESTRICT clause F031-16 Core DROP VIEW statement: RESTRICT clause F031-19 Core REVOKE statement: RESTRICT clause F032 CASCADE drop behavior F033 ALTER TABLE statement: DROP COLUMN clause F034 Extended REVOKE statement F034-01 REVOKE statement performed by other than the owner of a schema object F034-02 REVOKE statement: GRANT OPTION FOR clause F034-03 REVOKE statement to revoke a privilege that the grantee has WITH GRANT OPTION F041 Core Basic joined table F041-01 Core Inner join (but not necessarily the INNER keyword) F041-02 Core INNER keyword F041-03 Core LEFT OUTER JOIN F041-04 Core RIGHT OUTER JOIN F041-05 Core Outer joins can be nested F041-07 Core The inner table in a left or right outer join can also be used in an inner join F041-08 Core All comparison operators are supported (rather than just =) F051 Core Basic date and time F051-01 Core DATE data type (including support of DATE literal) F051-02 Core TIME data type (including support of TIME literal) with fractional seconds precision of at least 0 F051-03 Core TIMESTAMP data type (including support of TIMESTAMP literal) with fractional seconds precision of at least 0 and 6 F051-04 Core Comparison predicate on DATE, TIME, and TIMESTAMP data types F051-05 Core Explicit CAST between datetime types and character string types F051-06 Core CURRENT_DATE F051-07 Core LOCALTIME F051-08 Core LOCALTIMESTAMP F052 Enhanced datetime facilities Intervals and datetime arithmetic F053 OVERLAPS predicate F081 Core UNION and EXCEPT in views F111 Isolation levels other than SERIALIZABLE F111-01 READ UNCOMMITTED isolation level F111-02 READ COMMITTED isolation level F111-03 REPEATABLE READ isolation level F131 Core Grouped operations F131-01 Core WHERE, GROUP BY, and HAVING clauses supported in queries with grouped views F131-02 Core Multiple tables supported in queries with grouped views F131-03 Core Set functions supported in queries with grouped views F131-04 Core Subqueries with GROUP BY and HAVING clauses and grouped views F131-05 Core Single row SELECT with GROUP BY and HAVING clauses and grouped views F171 Multiple schemas per user F191 Enhanced integrity management Referential delete actions F200 TRUNCATE TABLE statement F201 Core CAST function F221 Core Explicit defaults F222 INSERT statement: DEFAULT VALUES clause F231 Privilege tables F231-01 TABLE_PRIVILEGES view F231-02 COLUMN_PRIVILEGES view F231-03 USAGE_PRIVILEGES view F251 Domain support F261 Core CASE expression F261-01 Core Simple CASE F261-02 Core Searched CASE F261-03 Core NULLIF F261-04 Core COALESCE F262 Extended CASE expression F271 Compound character literals F281 LIKE enhancements F302 INTERSECT table operator F302-01 INTERSECT DISTINCT table operator F302-02 INTERSECT ALL table operator F304 EXCEPT ALL table operator F311-01 Core CREATE SCHEMA F311-02 Core CREATE TABLE for persistent base tables F311-03 Core CREATE VIEW F311-04 Core CREATE VIEW: WITH CHECK OPTION F311-05 Core GRANT statement F321 User authorization F361 Subprogram support F381 Extended schema manipulation F381-01 ALTER TABLE statement: ALTER COLUMN clause F381-02 ALTER TABLE statement: ADD CONSTRAINT clause F381-03 ALTER TABLE statement: DROP CONSTRAINT clause F382 Alter column data type F383 Set column not null clause F391 Long identifiers F392 Unicode escapes in identifiers F393 Unicode escapes in literals F401 Extended joined table F401-01 NATURAL JOIN F401-02 FULL OUTER JOIN F401-04 CROSS JOIN F402 Named column joins for LOBs, arrays, and multisets F411 Enhanced datetime facilities Time zone specification differences regarding literal interpretation F421 National character F431 Read-only scrollable cursors F431-01 FETCH with explicit NEXT F431-02 FETCH FIRST F431-03 FETCH LAST F431-04 FETCH PRIOR F431-05 FETCH ABSOLUTE F431-06 FETCH RELATIVE F441 Extended set function support F442 Mixed column references in set functions F471 Core Scalar subquery values F481 Core Expanded NULL predicate F491 Enhanced integrity management Constraint management F501 Core Features and conformance views F501-01 Core SQL_FEATURES view F501-02 Core SQL_SIZING view F501-03 Core SQL_LANGUAGES view F502 Enhanced documentation tables F502-01 SQL_SIZING_PROFILES view F502-02 SQL_IMPLEMENTATION_INFO view F502-03 SQL_PACKAGES view F531 Temporary tables F555 Enhanced datetime facilities Enhanced seconds precision F561 Full value expressions F571 Truth value tests F591 Derived tables F611 Indicator data types F641 Row and table constructors F651 Catalog name qualifiers F661 Simple tables F672 Retrospective check constraints F690 Collation support but no character set support F692 Extended collation support F701 Enhanced integrity management Referential update actions F711 ALTER domain F731 INSERT column privileges F751 View CHECK enhancements F761 Session management F762 CURRENT_CATALOG F763 CURRENT_SCHEMA F771 Connection management F781 Self-referencing operations F791 Insensitive cursors F801 Full set function F850 Top-level <order by clause> in <query expression> F851 <order by clause> in subqueries F852 Top-level <order by clause> in views F855 Nested <order by clause> in <query expression> F856 Nested <fetch first clause> in <query expression> F857 Top-level <fetch first clause> in <query expression> F858 <fetch first clause> in subqueries F859 Top-level <fetch first clause> in views F860 <fetch first row count> in <fetch first clause> F861 Top-level <result offset clause> in <query expression> F862 <result offset clause> in subqueries F863 Nested <result offset clause> in <query expression> F864 Top-level <result offset clause> in views F865 <offset row count> in <result offset clause> S071 Enhanced object support SQL paths in function and type name resolution S092 Arrays of user-defined types S095 Array constructors by query S096 Optional array bounds S098 ARRAY_AGG S111 Enhanced object support ONLY in query expressions S201 SQL-invoked routines on arrays S201-01 Array parameters S201-02 Array as result type of functions S211 Enhanced object support User-defined cast functions T031 BOOLEAN data type T071 BIGINT data type T121 WITH (excluding RECURSIVE) in query expression T122 WITH (excluding RECURSIVE) in subquery T131 Recursive query T132 Recursive query in subquery T141 SIMILAR predicate T151 DISTINCT predicate T152 DISTINCT predicate with negation T171 LIKE clause in table definition T172 AS subquery clause in table definition T173 Extended LIKE clause in table definition T191 Enhanced integrity management Referential action RESTRICT T201 Enhanced integrity management Comparable data types for referential constraints T211-01 Active database, Enhanced integrity management Triggers activated on UPDATE, INSERT, or DELETE of one base table T211-02 Active database, Enhanced integrity management BEFORE triggers T211-03 Active database, Enhanced integrity management AFTER triggers T211-04 Active database, Enhanced integrity management FOR EACH ROW triggers T211-05 Active database, Enhanced integrity management Ability to specify a search condition that must be true before the trigger is invoked T211-07 Active database, Enhanced integrity management TRIGGER privilege T212 Enhanced integrity management Enhanced trigger capability T213 INSTEAD OF triggers T231 Sensitive cursors T241 START TRANSACTION statement T271 Savepoints T281 SELECT privilege with column granularity T312 OVERLAY function T321-01 Core User-defined functions with no overloading T321-03 Core Function invocation T321-06 Core ROUTINES view T321-07 Core PARAMETERS view T323 Explicit security for external routines T325 Qualified SQL parameter references T331 Basic roles T341 Overloading of SQL-invoked functions and procedures T351 Bracketed SQL comments (/*...*/ comments) T441 ABS and MOD functions T461 Symmetric BETWEEN predicate T491 LATERAL derived table T501 Enhanced EXISTS predicate T551 Optional key words for default syntax T581 Regular expression substring function T591 UNIQUE constraints of possibly null columns T614 NTILE function T615 LEAD and LAG functions T617 FIRST_VALUE and LAST_VALUE function T621 Enhanced numeric functions T631 Core IN predicate with one list element T651 SQL-schema statements in SQL routines T655 Cyclically dependent routines X010 XML type X011 Arrays of XML type X016 Persistent XML values X020 XMLConcat X031 XMLElement X032 XMLForest X034 XMLAgg X035 XMLAgg: ORDER BY option X036 XMLComment X037 XMLPI X040 Basic table mapping X041 Basic table mapping: nulls absent X042 Basic table mapping: null as nil X043 Basic table mapping: table as forest X044 Basic table mapping: table as element X045 Basic table mapping: with target namespace X046 Basic table mapping: data mapping X047 Basic table mapping: metadata mapping X048 Basic table mapping: base64 encoding of binary strings X049 Basic table mapping: hex encoding of binary strings X050 Advanced table mapping X051 Advanced table mapping: nulls absent X052 Advanced table mapping: null as nil X053 Advanced table mapping: table as forest X054 Advanced table mapping: table as element X055 Advanced table mapping: target namespace X056 Advanced table mapping: data mapping X057 Advanced table mapping: metadata mapping X058 Advanced table mapping: base64 encoding of binary strings X059 Advanced table mapping: hex encoding of binary strings X060 XMLParse: Character string input and CONTENT option X061 XMLParse: Character string input and DOCUMENT option X070 XMLSerialize: Character string serialization and CONTENT option X071 XMLSerialize: Character string serialization and DOCUMENT option X072 XMLSerialize: Character string serialization X090 XML document predicate X120 XML parameters in SQL routines X121 XML parameters in external routines X400 Name and identifier mapping X410 Alter column data type: XML type