Referential delete actions
Derby Reference Manual
217
Feature
Source
Derby
Group by
SQL92E
Yes
Having
SQL92E
Yes
Aggregate functions
SQL92E
Yes
Order by
SQL92E
Yes
Select expressions
SQL92E
Yes
Select *
SQL92E
Yes
SQLCODE
SQL92E
No, deprecated in
SQL-92
SQLSTATE
SQL92E
Yes
UNION, INTERSECT, and
EXCEPT in views
SQL92T
Yes
Implicit numeric casting
SQL92T
Yes
Implicit character casting
SQL92T
Yes
Get diagnostics
SQL92T
Use JDBC
SQLExceptions
Grouped operations
SQL92T
Yes
Qualified * in select list
SQL92T
Yes
Lowercase identifiers
SQL92T
Yes
nullable PRIMARY KEYs
SQL92T
No
Multiple module support
SQL92T
No (not required and not
part of JDBC)
Referential delete actions
SQL92T
CASCADE, SET NULL,
RESTRICT, and NO
ACTION
CAST functions
SQL92T
Yes
INSERT expressions
SQL92T
Yes
Explicit defaults
SQL92T
Yes
Keyword relaxations
SQL92T
Yes
Domain definition
SQL92I
No
CASE expression
SQL92I
Partial support
Compound character string
constants
SQL92I
Use concatenation
LIKE enhancements
SQL92I
Yes
UNIQUE predicate
SQL92I
No
Usage tables
SQL92I
SYS.SYSDEPENDS
Intermediate information schema
SQL92I
Use JDBC
DatabaseMetaData and
Derby system tables
