Specifies a list of names of columns in the table or view. You
can list the columns in any order, but the names must correspond
to those of the table or view.
If you do not include all the column names in the list, SQL
assigns a null value to those not specified, unless columns were:
o Defined with a default
o Based on a domain that has a default
o Defined with the NOT NULL clause in the CREATE TABLE statement
You cannot omit from an INSERT statement the names of columns
defined with the NOT NULL clause. If you do, the statement fails.
Omitting the list of column names altogether is the same as
listing all the columns of the table or view in the same order
as they were defined.
You must omit the list of column names when using the INSERT
statement to assign values to the segments in a column of data
type LIST OF BYTE VARYING. Column names are not valid in this
context.