Tricks of the VALUES clause
This section contains some tips to use with the VALUES clause.
- Multiple rows
Derby supports the complete SQL-92 VALUES clause; this is very handy in several cases.
- Mapping column values to return values
Multiple-row VALUES tables are useful in mapping column values to desired return values in queries.
- Creating empty queries
You may need Derby to create "empty" queries in existing applications for filling in bits of functionality that Derby does not supply.