Check & Default

CHECK and DEFAULT Constraints

CHECK

CREATE TABLE employees (
  emp_id NUMBER,
  salary NUMBER CHECK (salary > 0)
);

DEFAULT

CREATE TABLE employees (
  emp_id NUMBER,
  hire_date DATE DEFAULT SYSDATE
);