Support for SQL-92 features: Cursors
Derby Reference Manual
213
Feature
Source
Derby
IN, ALL/SOME, EXISTS
SQL92E
Yes
Table 20.
Support for SQL-92 features: schema definition
Feature
Source
Derby
Tables
SQL92E
Yes
Views
SQL92E
Yes
Privileges
SQL92E
Yes
Table 21.
Support for SQL-92 features: column attributes
Feature
Source
Derby
Default values
SQL92E
Yes
Nullability
SQL92E
Yes
Table 22.
Support for SQL-92 features: constraints (non-deferrable)
Feature
Source
Derby
NOT NULL
SQL92E
Yes (not stored in
SYSCONSTRAINTS)
UNIQUE/PRIMARY KEY
SQL92E
Yes
FOREIGN KEY
SQL92E
Yes
CHECK
SQL92E
Yes
View WITH CHECK OPTION
SQL92E
No, views cannot be
updated
Table 23.
Support for SQL-92 features: Cursors
Feature
Source
Derby
DECLARE, OPEN, FETCH,
CLOSE
SQL92E
Yes, by using JDBC
method calls
UPDATE, DELETE CURRENT
SQL92E
Yes
Table 24.
Support for SQL-92 features: Dynamic SQL 1
Feature
Source
Derby
ALLOCATE / DEALLOCATE /
GET / SET DESCRIPTOR
SQL92T
Yes, by using JDBC
method calls
PREPARE / EXECUTE /
EXECUTE IMMEDIATE
SQL92T
Yes, by using JDBC
method calls
DECLARE, OPEN, FETCH,
CLOSE, UPDATE, DELETE
dynamic cursor
SQL92T
Yes, by using JDBC
method calls
