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.