Insert Defaults


You can now insert the default value (if it exists) for column. To quote from the documentation

For both types of insert operations, if you specify a column list in the insert_into_clause, then Oracle assigns to each column in the list a corresponding value from the values clause or the subquery. You can specify DEFAULT for any value in the values_clause. If you have specified a default value for the corresponding column of the table or view, that value is inserted. If no default value for the corresponding column has been specified, Oracle inserts null.