create table student(
student_id varchar(10),
name varchar(50),
sex varchar(10)
);
insert into student values('0701001','王玲','女');
insert into student values('0702013',' 李力','男');
create table score(
student_id varchar(10),
english number,
math number,
computer number,
physics number,
is_pass_cet4 varchar(10),
score_avg number,
totle_score number
);
insert into score values('0701001',90.5,88.5,87,82,'yes',null,null);
纯粹是按照你的数据选择的数据类型,按照Oracle写的