CHECK Constraint

CHECK Constraint :

Defines a condition that each row must satisfy

• The following expressions are not allowed :
• References to CURR_VAL, NEXT_VAL and CTID pseudocolumns
• Queries that refer to other values in other rows
• ..., salary numeric(2)CONSTRAINT emp_salary_minCHECK (salary > 0),...

CREATE TABLE : Example