helpinghand
search
needassistance

Core SQL-99

The following table lists all features included in Core SQL-99.

Feature IDFeature Name
B011Embedded Ada *)
B012Embedded C *)
B013Embedded COBOL *)
B014Embedded Fortran *)
B015Embedded MUMPS *)
B016Embedded Pascal *)
B017Embedded PL/I 1 *)
E011Numeric data types
E011-01INTEGER and SMALLINT data types (including all spellings)
E011-02REAL, DOUBLE PRECISON, and FLOAT data types
E011-03DECIMAL and NUMERIC data types
E011-04Arithmetic operators
E011-05Numeric comparison
E011-06Implicit casting among the numeric data types
E021Character data types
E021-01CHARACTER data type (including all its spellings)
E021-02CHARACTER VARYING data type (including all its spellings)
E021-03Character literals
E021-04CHARACTER_LENGTH function
E021-05OCTET_LENGTH function
E021-06SUBSTRING function
E021-07Character concatenation
E021-08UPPER and LOWER functions
E021-09TRIM function
E021-10Implicit casting among the character data types
E021-11POSITION function
E011-12Character comparison
E031Identifiers
E031-01Delimited identifiers
E031-02Lower case identifiers
E031-03Trailing underscore
E051Basic query specification
E051-01SELECT DISTINCT
E051-02GROUP BY clause
E051-04GROUP BY can contain columns not in select-list
E051-05Select list items can be renamed
E051-06HAVING clause
E051-07Qualified * in select list
E051-08Correlation names in the FROM clause
E051-09Rename columns in the FROM clause
E061Basic predicates and search conditions
E061-01Comparison predicate
E061-02BETWEEN predicate
E061-03IN predicate with list of values
E061-04LIKE predicate
E061-05LIKE predicate: ESCAPE clause
E061-06NULL predicate
E061-07Quantified comparison predicate
E061-08EXISTS predicate
E061-09Subqueries in comparison predicate
E061-11Subqueries in IN predicate
E061-12Subqueries in quantified comparison predicate
E061-13Correlated subqueries
E061-14Search condition
E071Basic query expressions
E071-01UNION DISTINCT table operator
E071-02UNION ALL table operator
E071-03EXCEPT DISTINCT table operator
E071-05Columns combined via table operators need not have exactly the same data type
E071-06Table operators in subqueries
E081Basic Privileges
E081-01SELECT privilege at the table level
E081-02DELETE privilege
E081-03INSERT privilege at the table level
E081-04UPDATE privilege at the table level
E081-05UPDATE privilege at the column level
E081-06REFERENCES privilege at the table level
E081-07REFERENCES privilege at the column level
E081-08WITH GRANT OPTION
E081-09USAGE privilege
E081-10EXECUTE privilege
E091Set functions
E091-01AVG
E091-02COUNT
E091-03MAX
E091-04MIN
E091-05SUM
E091-06ALL quantifier
E091-07DISTINCT quantifier
E101Basic data manipulation
E101-01INSERT statement
E101-03Searched UPDATE statement
E101-04Searched DELETE statement
E111Single row SELECT statement
E121Basic cursor support
E121-01DECLARE CURSOR
E121-02ORDER BY columns need not be in select list
E121-03Value expressions in ORDER BY clause
E121-04OPEN statement
E121-06Positioned UPDATE statement
E121-07Positioned DELETE statement
E121-08CLOSE statement
E121-10FETCH statement: implicit NEXT
E121-17WITH HOLD cursors
E131Null value support (nulls in lieu of values)
E141Basic integrity constraints
E141-01NOT NULL constraints
E141-02UNIQUE constraints of NOT NULL columns
E141-03PRIMARY KEY constraints
E141-04Basic FOREIGN KEY constraint with the NO ACTION default
E141-06CHECK constraints
E141-07Column defaults
E141-08NOT NULL inferred on PRIMARY KEY
E141-10Names in a foreign key can be specified in any order
E151Transaction support
E151-01COMMIT statement
E151-02ROLLBACK statement
E152Basic SET TRANSACTION statement
E152-01SET TRANSACTION statement: ISOLATION LEVEL SERIALIZABLE clause
E152-02SET TRANSACTION statement: READ ONLY and READ WRITE clauses
E153Updatable queries with subqueries
E161SQL comments using leading double minus
E171SQLSTATE support
F021Basic information schema
F021-01COLUMNS view
F021-02TABLES view
F021-03VIEWS view
F021-04TABLE_CONSTRAINTS view
F021-05REFERENTIAL_CONSTRAINTS view
F021-06CHECK_CONSTRAINTS view
F031Basic schema manipulation
F031-01CREATE TABLE statement to create persistent base tables
F031-02CREATE VIEW statement
F031-03GRANT statement
F031-04ALTER TABLE statement: ADD COLUMN clause
F031-13DROP TABLE statement: RESTRICT clause
F031-16DROP VIEW statement: RESTRICT clause
F031-19REVOKE statement: RESTRICT clause
F041Basic joined table
F041-01Inner join (but not necessarily the INNER keyword)
F041-02INNER keyword
F041-03LEFT OUTER JOIN
F041-04RIGHT OUTER JOIN
F041-05Outer joins can be nested
F041-07The inner table in a left or right outer join can also be used in an inner join
F041-08All comparison operators are supported (rather than just =)
F051Basic date and time
F051-01DATE data type (including DATE literal)
F051-02TIME data type (including TIME literal) with fractional seconds precision of 0
F051-03TIMESTAMP data type (including TIMESTAMP literal) with fractional seconds precision of 0 and 6
F051-04Comparison predicate on DATE, TIME, and TIMESTAMP data types
F051-05Explicit CAST between datetime types and character types
F051-06CURRENT_DATE
F051-07LOCALTIME
F051-08LOCALTIMESTAMP
F081UNION and EXCEPT in views
F131Grouped operations
F131-01WHERE, GROUP BY, and HAVING clauses supported in queries with grouped views
F131-02Multiple tables supported in queries with grouped views
F131-03Set functions supported in queries with grouped views
F131-04Subqueries with GROUP BY and HAVING clauses and grouped views
F131-05Single row SELECT with GROUP BY and HAVING clauses and grouped views
F181Multiple module support
F201CAST function
F221Explicit defaults
F261CASE expression
F261-01Simple CASE
F261-02Searched CASE
F261-03NULLIF
F261-04COALESCE
F311Schema definition statement
F311-01CREATE SCHEMA
F311-02CREATE TABLE for persistent base tables
F311-03CREATE VIEW
F311-04CREATE VIEW: WITH CHECK OPTION
F311-05GRANT statement
F471Scalar subquery values
F481Expanded NULL predicate
F501Features and conformance views
F501-01SQL_FEATURES view
F501-02SQL_SIZING view
F501-03SQL_LANGUAGES view
F812Basic flagging
S011Distinct data types
S011-01USER_DEFINED_TYPES view
T321Basic SQL-invoked routines
T321-01User-defined functions with no overloading
T321-02User-defined stored procedures with no overloading
T321-03Function invocation
T321-04CALL statement
T321-05RETURN statement
T321-06ROUTINES view
T321-07PARAMETERS view

*) A conforming SQL-implementation is required to support at least one embedded language.

 

Powered by Mimer SQL

Powered by Mimer SQL