CHECK
1.They can be created using CREATE TABLE or ALTER TABLE
CREATE TABLE BONUD(
EMP_ID VARCHAR2(40) NOT NULL,
SALARY NUMBER(9,2),
BONUS NUMBER(9,2),
CONSTRAINT CK_BONUS CHECK(BONUS>0));
)
ALTER TABLE BONUS ADD CONSTRAINT CK_BONUS2 CHECK (BONUS < SALARY)