SQL Data Type: String (BLOB, or Character (CLOB))

The ability to store either bit images or large character documents

SQL Data Type: Boolean

The ability to specify boolean data types, logic, and supporting rules

SQL Data Type: Ref Types

The ability to have a DBMS generated or column value based pointer as a reference between rows of different tables.

SQL Data Type: Arrays

The ability to have an ordered list of values within a column. Each value may be a RefType. Each may also be a ROW data structure

SQL Data Type: ROW Data Structures

The ability to have groups of "subcolumns" within a column. Each may be an array or a RefType

SQL Data Type: User Defined Types

The ability to completely define an non-traditional data type such as nautical distance.

Triggers

The ability to specify the instigation of an action as a consequence of a state change in the database

Savepoints

The ability to have cascading sets of "soft" commits that can be rolled back until there is a traditional hard-commit

Roles Security Enhancement

The ability to define additional layers and kinds of security and the assignment of persons fulfilling the defined roles

Recursion

The ability to fully model nested relationships such as hierarchies for organizations.

Information Schema

A virtual database defined as virtual tables and real SQL views on the virtual tables that contain the complete set of metadata in support of defined databases.

Call Level Interface

The complete specification of a DBMS vendor independent set of database access routines similar to that contained in the Microsoft ODBC specification.

SQL Multi-Media: Full Text

The complete set of data structures, special full-text operations and SQL routines that support the loading, accessing, and maintenance of full-text type of data such as books, manuscripts.

SQL Multi-Media: Spatial

The complete library or set of data structures and routines that support spatial data types and operations on those data types

SQL Multi-Media: Still Image

The complete library or set of data structures and routines that support still image data types and operations on those data types

SQL Programming Language

A complete SQL DBMS encapsulated programming language that includes traditional assignment, looping, branching, If..Then...Else, and CASE type constructs.

Transaction, Connection, Session, and Diagnostics Management

The ability to specify sessions and the management of those sessions in support of centralized or distributed type batch-type processing.

SQL/MED

The routines and facilities in support of the management of types and classes of data that exists outside the domain of SQL.