INSERT without column list

The column list for the insert statement is missing.

An explicit column list is not required for an INSERT statement. However, omitting the column list implicitly assumes the order of columns in the table. If the table is changed and columns are reordered, the INSERT may fail or insert data into the wrong column.

Available in

 SQL Monitor

SQL Prompt

 SQL Code Guard