---

Check Constraints

---

A Check Constraints allows an entered value to be checked against a set of defined conditions.

You can check student average marks between 0 and 60, and employee present in a year in days between 0 and 250. You can check your answer is either yes or no.

---

Example of Check Constraints

---

create table student(s_id number(10), s_name varchar2(15), status number(3) constraint st check(status=’pt’or status=’ft’));

---