Referencing row variables in INSERT statements

Row variables can be used in INSERT statements to append or modify an entire table row.

The following is an example of an INSERT statement that inserts a row into tabled employee:

INSERT INTO employee VALUES empRow;

For the INSERT statement, the number of fields in the row variable must match the number of columns in the implicit or explicit target column list.

The INSERT statement shown previously inserts into each column in the table, the corresponding row field value. Thus the previously shown INSERT statement is equivalent to the following INSERT statement:

INSERT INTO employee VALUES (emp.id, 
                             emp.name,
                             emp.salary,
                             emp.phone);