Filter
Top Products
[Table: Time interval specifications]
Default value
A value can be specified as a default value for a column. Specify a value to be set in the column if no value is
specified when a row is inserted in the table. The defaults can be specified with a constant, login name (under UNIX)
or logon name (under Windows NT/2000/XP), NULL, the current date, the current time, and the current timestamp.
Example 1:
Sample column definition for the ITMNO column of the STOCK table
Example 2:
Sample column definition for using a sequence for the ITMNO column of the STOCK table
Column constraint
A constraint on the data to be stored can be specified for a column. Specify a constraint after the data type
specification. The following two kinds of column constraints can be specified:
38