Search notes:
Oracle: NOT NULL constraint
The not
null
constraint
prevents a column value from being
null
. Thus, the
not null
constraint is a special
check constraint
.
Columns that are part of a
primary key
or
identity columns
are always
not null
.
See also
The
error messages
:
ORA-01400: cannot insert NULL into …
ORA-01407: cannot update … to NULL
ORA-01442: column to be modified to NOT NULL is already NOT NULL
Index