📄 sql_features.txt
字号:
B011 Embedded Ada NO B012 Embedded C YES 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 B032 Extended dynamic SQL 01 <describe input statement> NO B033 Untyped SQL-invoked function arguments NO B034 Dynamic specification of cursor attributes 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 C011 Call-Level Interface NO E011 Numeric data types YES E011 Numeric data types 01 INTEGER and SMALLINT data types YES E011 Numeric data types 02 REAL, DOUBLE PRECISION, and FLOAT data types YES E011 Numeric data types 03 DECIMAL and NUMERIC data types YES E011 Numeric data types 04 Arithmetic operators YES E011 Numeric data types 05 Numeric comparison YES E011 Numeric data types 06 Implicit casting among the numeric data types YES E021 Character data types YES E021 Character string types 01 CHARACTER data type YES E021 Character string types 02 CHARACTER VARYING data type YES E021 Character string types 03 Character literals YES E021 Character string types 04 CHARACTER_LENGTH function YES trims trailing spaces from CHARACTER values before countingE021 Character string types 05 OCTET_LENGTH function YES E021 Character string types 06 SUBSTRING function YES E021 Character string types 07 Character concatenation YES E021 Character string types 08 UPPER and LOWER functions YES E021 Character string types 09 TRIM function YES E021 Character string types 10 Implicit casting among the character string types YES E021 Character string types 11 POSITION function YES E021 Character string types 12 Character comparison YES E031 Identifiers YES E031 Identifiers 01 Delimited identifiers YES E031 Identifiers 02 Lower case identifiers YES E031 Identifiers 03 Trailing underscore YES E051 Basic query specification YES E051 Basic query specification 01 SELECT DISTINCT YES E051 Basic query specification 02 GROUP BY clause YES E051 Basic query specification 04 GROUP BY can contain columns not in <select list> YES E051 Basic query specification 05 Select list items can be renamed YES AS is requiredE051 Basic query specification 06 HAVING clause YES E051 Basic query specification 07 Qualified * in select list YES E051 Basic query specification 08 Correlation names in the FROM clause YES E051 Basic query specification 09 Rename columns in the FROM clause YES E061 Basic predicates and search conditions YES E061 Basic predicates and search conditions 01 Comparison predicate YES E061 Basic predicates and search conditions 02 BETWEEN predicate YES E061 Basic predicates and search conditions 03 IN predicate with list of values YES E061 Basic predicates and search conditions 04 LIKE predicate YES E061 Basic predicates and search conditions 05 LIKE predicate ESCAPE clause YES E061 Basic predicates and search conditions 06 NULL predicate YES E061 Basic predicates and search conditions 07 Quantified comparison predicate YES E061 Basic predicates and search conditions 08 EXISTS predicate YES E061 Basic predicates and search conditions 09 Subqueries in comparison predicate YES E061 Basic predicates and search conditions 11 Subqueries in IN predicate YES E061 Basic predicates and search conditions 12 Subqueries in quantified comparison predicate YES E061 Basic predicates and search conditions 13 Correlated subqueries YES E061 Basic predicates and search conditions 14 Search condition YES E071 Basic query expressions YES E071 Basic query expressions 01 UNION DISTINCT table operator YES E071 Basic query expressions 02 UNION ALL table operator YES E071 Basic query expressions 03 EXCEPT DISTINCT table operator YES E071 Basic query expressions 05 Columns combined via table operators need not have exactly the same data type YES E071 Basic query expressions 06 Table operators in subqueries YES E081 Basic Privileges NO E081 Basic Privileges 01 SELECT privilege YES E081 Basic Privileges 02 DELETE privilege YES E081 Basic Privileges 03 INSERT privilege at the table level YES E081 Basic Privileges 04 UPDATE privilege at the table level YES E081 Basic Privileges 05 UPDATE privilege at the column level NO E081 Basic Privileges 06 REFERENCES privilege at the table level YES E081 Basic Privileges 07 REFERENCES privilege at the column level NO E081 Basic Privileges 08 WITH GRANT OPTION YES E081 Basic Privileges 09 USAGE privilege NO E081 Basic Privileges 10 EXECUTE privilege YES E091 Set functions YES E091 Set functions 01 AVG YES E091 Set functions 02 COUNT YES E091 Set functions 03 MAX YES E091 Set functions 04 MIN YES E091 Set functions 05 SUM YES E091 Set functions 06 ALL quantifier YES E091 Set functions 07 DISTINCT quantifier YES E101 Basic data manipulation YES E101 Basic data manipulation 01 INSERT statement YES E101 Basic data manipulation 03 Searched UPDATE statement YES E101 Basic data manipulation 04 Searched DELETE statement YES E111 Single row SELECT statement YES E121 Basic cursor support NO E121 Basic cursor support 01 DECLARE CURSOR YES E121 Basic cursor support 02 ORDER BY columns need not be in select list YES E121 Basic cursor support 03 Value expressions in ORDER BY clause YES E121 Basic cursor support 04 OPEN statement YES E121 Basic cursor support 06 Positioned UPDATE statement NO E121 Basic cursor support 07 Positioned DELETE statement NO E121 Basic cursor support 08 CLOSE statement YES E121 Basic cursor support 10 FETCH statement implicit NEXT YES E121 Basic cursor support 17 WITH HOLD cursors YES E131 Null value support (nulls in lieu of values) YES E141 Basic integrity constraints YES E141 Basic integrity constraints 01 NOT NULL constraints YES E141 Basic integrity constraints 02 UNIQUE constraints of NOT NULL columns YES E141 Basic integrity constraints 03 PRIMARY KEY constraints YES E141 Basic integrity constraints 04 Basic FOREIGN KEY constraint with the NO ACTION default for both referential delete action and referential update action YES E141 Basic integrity constraints 06 CHECK constraints YES E141 Basic integrity constraints 07 Column defaults YES E141 Basic integrity constraints 08 NOT NULL inferred on PRIMARY KEY YES E141 Basic integrity constraints 10 Names in a foreign key can be specified in any order YES E151 Transaction support YES E151 Transaction support 01 COMMIT statement YES E151 Transaction support 02 ROLLBACK statement YES E152 Basic SET TRANSACTION statement YES E152 Basic SET TRANSACTION statement 01 SET TRANSACTION statement: ISOLATION LEVEL SERIALIZABLE clause YES E152 Basic SET TRANSACTION statement 02 SET TRANSACTION statement: 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 Basic information schema 01 COLUMNS view YES F021 Basic information schema 02 TABLES view YES F021 Basic information schema 03 VIEWS view YES F021 Basic information schema 04 TABLE_CONSTRAINTS view YES F021 Basic information schema 05 REFERENTIAL_CONSTRAINTS view YES F021 Basic information schema 06 CHECK_CONSTRAINTS view YES F031 Basic schema manipulation YES F031 Basic schema manipulation 01 CREATE TABLE statement to create persistent base tables YES F031 Basic schema manipulation 02 CREATE VIEW statement YES F031 Basic schema manipulation 03 GRANT statement YES F031 Basic schema manipulation 04 ALTER TABLE statement: ADD COLUMN clause YES F031 Basic schema manipulation 13 DROP TABLE statement: RESTRICT clause YES F031 Basic schema manipulation 16 DROP VIEW statement: RESTRICT clause YES F031 Basic schema manipulation 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 Extended REVOKE statement 01 REVOKE statement performed by other than the owner of a schema object YES F034 Extended REVOKE statement 02 REVOKE statement: GRANT OPTION FOR clause YES F034 Extended REVOKE statement 03 REVOKE statement to revoke a privilege that the grantee has WITH GRANT OPTION YES F041 Basic joined table YES F041 Basic joined table 01 Inner join (but not necessarily the INNER keyword) YES F041 Basic joined table 02 INNER keyword YES F041 Basic joined table 03 LEFT OUTER JOIN YES F041 Basic joined table 04 RIGHT OUTER JOIN YES F041 Basic joined table 05 Outer joins can be nested YES F041 Basic joined table 07 The inner table in a left or right outer join can also be used in an inner join YES F041 Basic joined table 08 All comparison operators are supported (rather than just =) YES F051 Basic date and time YES F051 Basic date and time 01 DATE data type (including support of DATE literal) YES F051 Basic date and time 02 TIME data type (including support of TIME literal) with fractional seconds precision of at least 0 YES F051 Basic date and time 03 TIMESTAMP data type (including support of TIMESTAMP literal) with fractional seconds precision of at least 0 and 6 YES F051 Basic date and time 04 Comparison predicate on DATE, TIME, and TIMESTAMP data types YES F051 Basic date and time 05 Explicit CAST between datetime types and character string types YES F051 Basic date and time 06 CURRENT_DATE YES F051 Basic date and time 07 LOCALTIME YES F051 Basic date and time 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 Isolation levels other than SERIALIZABLE 01 READ UNCOMMITTED isolation level YES F111 Isolation levels other than SERIALIZABLE 02 READ COMMITTED isolation level YES F111 Isolation levels other than SERIALIZABLE 03 REPEATABLE READ isolation level YES F121 Basic diagnostics management NO F121 Basic diagnostics management 01 GET DIAGNOSTICS statement NO F121 Basic diagnostics management 02 SET TRANSACTION statement: DIAGNOSTICS SIZE clause NO F131 Grouped operations YES F131 Grouped operations 01 WHERE, GROUP BY, and HAVING clauses supported in queries with grouped views YES F131 Grouped operations 02 Multiple tables supported in queries with grouped views YES F131 Grouped operations 03 Set functions supported in queries with grouped views YES F131 Grouped operations 04 Subqueries with GROUP BY and HAVING clauses and grouped views YES F131 Grouped operations 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 YES F201 CAST function YES F221 Explicit defaults YES F222 INSERT statement: DEFAULT VALUES clause YES F231 Privilege tables YES F231 Privilege tables 01 TABLE_PRIVILEGES view YES F231 Privilege tables 02 COLUMN_PRIVILEGES view YES F231 Privilege tables 03 USAGE_PRIVILEGES view YES F251 Domain support YES F261 CASE expression YES F261 CASE expression 01 Simple CASE YES F261 CASE expression 02 Searched CASE YES F261 CASE expression 03 NULLIF YES F261 CASE expression 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 INTERSECT table operator 01 INTERSECT DISTINCT table operator YES F302 INTERSECT table operator 02 INTERSECT ALL table operator YES F304 EXCEPT ALL table operator YES F311 Schema definition statement NO F311 Schema definition statement 01 CREATE SCHEMA YES ⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -