sql;">
create table t_
score
(
autoid number primary key,s_id number(3),s_name char(8) not null,sub_name varchar2(20),
score number(10,2)
);
insert into t_
score (autoid,s_id,
score)
values (8,1,'张三 ','语文',80);
insert into t_
score (autoid,
score)
values (9,2,'李四 ','数学',
score)
values (10,0);
insert into t_
score (autoid,
score)
values (11,50);
insert into t_
score (autoid,
score)
values (12,3,'张三丰 ',10);
insert into t_
score (autoid,
score)
values (13,null);
insert into t_
score (autoid,
score)
values (14,'体育',120);
insert into t_
score (autoid,
score)
values (15,4,'杨过 ','java',90);
insert into t_
score (autoid,
score)
values (16,5,'mike ','c++',
score)
values (3,'oracle',
score)
values (4,77);
insert into t_
score (autoid,
score)
values (17,77);
commit;
