The Oracle INSERT statement allows you to insert data into an Oracle
table by inserting one or more rows of data.
The basic Oracle INSERT statement syntax is as follows:
insert into <table name> (col1, col2, col3,…)
values (val1, val2, val3,…);
If the values listed are in the same order as the table columns and
there is a value (even if it is NULL) for each column, you can leave out
the column list as in the example above. The easiest way to determine
which columns are in the table is to describe the table (SQL> desc
author) as we have been doing in our examples. If you exclude a column
from the Oracle INSERT statement, then the column list is mandatory
because the database needs to match the values to the columns. Excluded
columns will contain NULL unless the table has a default value defined
for that column.
For more information on Oracle INSERT statement see the notes below:
INSERT Statement Tips