data

create table student
(
 id number(10),

 name varchar2(30),

 cgpa number(3,2),

 phone varchar2(11));


desc student

insert into student values( 5, null,3.32, '0182535344');

select * from student

delete from student

alter table student

add constraint chk_student_cgpa

check (cgpa >=0 and cgpa<=4);





create table student
(
 id number(10),

 name varchar2(30),

 cgpa number(3,2),

 phone varchar2(11));


desc student

insert into student values( 5, null,3.32, '0182535344');

select * from student

delete from student

alter table student

add constraint chk_student_cgpa

check (cgpa >=0 and cgpa<=4);