All basic capabilities
Supports all BasicProfile features which do not have separate capability values
Supports default values in column definitions
Supports the database function to get the current database name.
Supports the user function to get the current database user.
Supports full outer joins
Supports right outer joins
Supports escape characters in "like"
Supports mutable result sets
Supports properly compositional paging in sub-queries
Returns only the requested number of rows even if some rows are not unique.
Can return primary key of inserted row
Can also return non-primary-key columns of inserted row
Supports sequences (real or emulated)
Can get current sequence value
Supports cyclic sequences
Supports non-cyclic limited sequences (with a max value)
Supports max value for sequences
Supports min value for sequences
Supports the Blob data type
Supports the Long data type
Supports zip, zipWith and zipWithIndex