Values Clause and Subselect
To specify the values to insert, use the values clause or a subselect.
• In the values clause, expression represents the value that you are inserting into the database.
• When you use a subselect, the values to insert are retrieved by the select statement. For more information about subselects, see
Select Statement (see
Select Statement).
You can omit the list of database columns if the inserted values come from a subselect and the column types in the subselect match the column types in the table in the order specified when the table was created.