Multiple Constraints

SQL> CREATE TABLE VENDORS
  2  (ID           NUMBER CONSTRAINT VENDOR_ID_PK PRIMARY KEY,
  3   NAME         VARCHAR2(20) NOT NULL,
  4   STATUS       NUMBER(1) CONSTRAINT STATUS_NN NOT NULL,
  5   CATEGORY     VARCHAR2(20),
  6   CONSTRAINT   STATUS_CK CHECK (STATUS IN (4, 5)),
  7   CONSTRAINT   CATEGORY_CK CHECK (CATEGORY IN ('Active','Suspended','Inactive'))
  8  );

Table created.

SQL>