An INSERT statement creates a row or rows and stores them in the
named table. The number of values assigned in an INSERT
statement must be the same as the number of specified or implied
columns. Whenever you insert into a table which has generated
columns, Derby calculates the values of those columns. INSERT
INTO table-Name [ (Simple-column-Name [ , Simple-column-Name]* )
] Query [ ORDER BY clause ] [ result offset clause ] [ fetch
first clause ] Single-row and multiple-row VALUES expressions
can include the keyword DEFAULT. Specifying DEFAULT for a column
inserts the column's default value into the column. Another way
to insert the default value into the column is to omit the
column from the column list and only insert values into other
columns in the table. For more information, see VALUES
expression. The DEFAULT literal is the only value which you can
directly insert into a generated column. When you want insertion
to happen with a specific ordering (for example, in conjunction
with auto-generated keys), i