<< TIMEZONE_MINUTE | Support for SQL-92 features: Cursors >>

Derby support for SQL-92 features

<< TIMEZONE_MINUTE | Support for SQL-92 features: Cursors >>

Derby Reference Manual

212

Derby support for SQL-92 features

There are four levels of SQL-92 support:

· SQL92E

Entry

· SQL92T

Transitional, a level defined by NIST in a publication called FIPS 127-2

· SQL92I

Intermediate

· SQL92F

Full

The following tables show Derby support for SQL-92 features.

Table 15.

Support for SQL-92 features: Basic data types

Feature

Source

Derby

SMALLINT

SQL92E

Yes

INTEGER

SQL92E

Yes

DECIMAL(p,s)

SQL92E

Yes

NUMERIC(p,s)

SQL92E

Yes

REAL

SQL92E

Yes

FLOAT(p)

SQL92E

Yes

DOUBLE PRECISION

SQL92E

Yes

CHAR(n)

SQL92E

Yes

Table 16.

Support for SQL-92 features: Basic math operations

Feature

Source

Derby

+, *, -, /, unary +, unary -

SQL92E

Yes

Table 17.

Support for SQL-92 features: Basic comparisons

Feature

Source

Derby

<, >, <= ,>=, <>, =

SQL92E

Yes

Table 18.

Support for SQL-92 features: Basic predicates

Feature

Source

Derby

BETWEEN, LIKE, NULL

SQL92E

Yes

Table 19.

Support for SQL-92 features: Quantified predicates