Check & Default
Published September 28, 2026
By Sai Sree Ram Gundepudi
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
);