Default Column Values

When you create a table, you can specify default values for the columns. The default value you specify must be compatible with the data type of the column.

You can specify one of the following default values for a column:

• NULL for any column type

• A constant value

• SYSDATE for DATE and TIMESTAMP columns

• USER for CHAR columns

• CURRENT_USER for CHAR columns

• SYSTEM_USER for CHAR columns

If you use the DEFAULT clause of the CREATE TABLE statement but do not specify the default value for one or more columns, those default values for those columns are NULL. See CREATE TABLE in the Oracle TimesTen In-Memory Database SQL Reference.