Check Constraint in Oracle with example

A check constraint requires a value in the database to comply with a specified condition.
below given one example for this,

SQL> Create table check_example2 (
2 name varchar(15),design varchar(15) ,
3 bpay number(7,2),da number(6,2),
4 constraint check2 check (da <=2500));

Table created.

SQL> insert into check_example2 values
2 ('&name','&design',&bpay,&da);
Enter value for name: Mahesh P
Enter value for design: CEO
Enter value for bpay: 20000
Enter value for da: 2000
old 2: ('&name','&design',&bpay,&da)
new 2: ('Mahesh P','CEO',20000,2000)

1 row created.

SQL> /
Enter value for name: Manoj
Enter value for design: MD
Enter value for bpay: 18000
Enter value for da: 1800
old 2: ('&name','&design',&bpay,&da)
new 2: ('Manoj','MD',18000,1800)

1 row created.

SQL> /
Enter value for name: Suraj
Enter value for design: clerk
Enter value for bpay: 10000
Enter value for da: 1200
old 2: ('&name','&design',&bpay,&da)
new 2: ('Suraj','clerk',10000,1200)

1 row created.

SQL> /
Enter value for name: Aneesh Babu
Enter value for design: CEO
Enter value for bpay: 22000
Enter value for da: 2600
old 2: ('&name','&design',&bpay,&da)
new 2: ('Aneesh Babu','CEO',22000,2600)
insert into check_example2 values
*
ERROR at line 1:
ORA-02290: check constraint (MAJI.CHECK2) violated