oracle教学课件尚硅谷宋红康09约束.ppt

The NOT NULL Constraint The NOT NULL constraint ensures that the column contains no null values. Columns without the NOT NULL constraint can contain null values by default. The NOT NULL Constraint (continued) The NOT NULL constraint can be specified only at the column level, not at the table level. The slide example applies the NOT NULL constraint to the LAST_NAME and HIRE_DATE columns of the EMPLOYEES table. Because these constraints are unnamed, the Oracle server creates names for them. You can specify the name of the constraint when you specify the constraint: ... last_name VARCHAR2(2