create table student(
sno varchar2(10),
sname varchar2(10),
sage date,
ssex varchar2(10)
)
insert into student values(01,‘赵雷’,to_date(‘1990-1-1’,‘YYYY-MM-DD’),‘男’);
insert into student values(02,‘钱电’,to_date(‘1990-12-21’,‘YYYY-MM-DD’),‘男’);
insert into student values(03,‘孙风’,to_date(‘1990-5-20’,‘YYYY-MM-DD’),‘男’);
insert into student values(04,‘李云’,to_date(‘1990-8-6’,‘YYYY-MM-DD’),‘男’);
insert into student values(05,‘周梅’,to_date(‘1991-12-1’,‘YYYY-MM-DD’),‘女’);
insert into student values(06,‘吴兰’,to_date(‘1992-3-1’,‘YYYY-MM-DD’),‘女’);
insert into student values(07,‘郑竹’,to_date(‘1989-7-1’,‘YYYY-MM-DD’),‘女’);
insert into student values(08,‘王菊’,to_date(‘1990-1-20’,‘YYYY-MM-DD’),‘女’);
select * from student;
create table course(
cno varchar2(10),
cname varchar2(10),
tno varchar2(10)
);
insert into course values(01,‘语文’,02);
insert into course values(02,‘数学’,01);
insert into course values(03,‘英语’,03);
select * from emp;
create table teacher(
tno varchar2(10),
tname varchar2(10)
);
insert into teacher values(01,‘张三’);
insert into teacher values(02,‘李四’);
insert into teacher values(03,‘王五’);
select * from teacher
create table sc(
sno varchar2(10),
cno varchar2(10),
score number(18,1)
);
insert into sc values(01,01,80);
insert into sc values(01,02,90);
insert into sc values(01,03,99);
insert into sc values(02,01,70);
insert into sc values(02,02,60);
insert into sc values(02,03,80);
insert into sc values(03,01,80);
insert into sc values(03,02,80);
insert into sc values(03,03,80);
insert into sc values(04,01,50);
insert into sc values(04,02,30);
insert into sc values(04,03,20);
insert into sc values(05,01,76);
insert into sc values(05,02,87);
insert into sc values(06,01,31);
insert into sc values(06,03,34);
insert into sc values(07,02,89);
insert into sc values(07,03,98);
select * from sc;