|
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 |
|
|
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-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
|
|
|
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 in
|
|
|
F851
|
|
in subqueries
|
|
|
F852
|
|
Top-level in views
|
|
|
F855
|
|
Nested in
|
|
|
F856
|
|
Nested in
|
|
|
F857
|
|
Top-level in
|
|
|
F858
|
|
in subqueries
|
|
|
F859
|
|
Top-level in views
|
|
|
F860
|
|
in
|
|
|
F861
|
|
Top-level in
|
|
|
F862
|
|
in subqueries
|
|
|
F863
|
|
Nested in
|
|
|
F864
|
|
Top-level in views
|
|
|
F865
|
|
in
|
|
|
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
|
|
|
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
|
|