Adds or modifies a constraint for the existing named domain.
Domain constraints specify that columns based on the domain
contain only certain data values or that data values can or
cannot be null.
Use the CHECK clause to specify that a value must be within a
specified range or that it matches a list of values. When you
specify a CHECK clause for a domain constraint, you ensure that
all values stored in columns based on the domain are checked
consistently.
To refer to the values of all columns of a domain constraint, use
the VALUE keyword. For example:
SQL> CREATE DOMAIN dom1 CHAR(1)
cont> CHECK (VALUE IN ('F','M'))
cont> NOT DEFERRABLE;
For any dialect other than SQL99, SQL92, ORACLE LEVEL 1 or
ORACLE LEVEL 2, you must specify that domain constraints are
NOT DEFERRABLE.
When you add (or modify) a domain constraint, SQL propagates
the new constraint definition to all the columns that are based
on the domain. If columns that are based on the domain contain
data that does not conform to the constraint, SQL returns the
following error:
%RDB-E-NOT_VALID, validation on field DATE_COL caused operation to fail