CHECK constraint
A CHECK
constraint attaches an expression to a constraint.
SQL> CREATE TABLE VENDORS
2 (ID NUMBER,
3 NAME VARCHAR2(20),
4 STATUS NUMBER(1) CHECK (STATUS IN (4,5)),
5 CATEGORY VARCHAR2(5)
6 );
Table created.
SQL>
Home »
Oracle »
Table »
Oracle »
Table »
Constraints:
- Adding a Constraint with CHECK
- Adding a NOT NULL Constraint
- Adding a FOREIGN KEY Constraint
- ON DELETE CASCADE
- ON DELETE SET NULL
- Adding a UNIQUE Constraint
- CHECK constraint
- Multiple Constraints
- Dropping a Constraint
- Disabling a Constraint
- Enabling a Constraint
- Deferred Constraints
- Getting Information on Constraints:user_constraints and all_constraints
Related: