--建立学生表create table student(sid number primary key , --这是学生的学号sname varchar2(45) not null, --学生姓名ssex char(2) not null,--性别sdept varchar2(10) not null, --所在系sage number(3) ,--年龄saddress varchar2(45) --住址)
--学生表中的数据insert into student values(20040001,'林青霞','F','计算机系',22,'上海');insert into student values(20040002,'刘德华','M','外语系',23,'南京');insert into student values(20050003,'成龙','M','化学系',21,'山东');insert into student values(20050004,'林可欣','F','计算机系',22,'北京');insert into student values(20050005,'周华健','M','生物系',24,'山东');insert into student values(20050006,'周润发','M','数学系',20,'湖北');
--建立课程表create table course(cid number primary key ,--这是课程号cname varchar2(50) not null,--课程名ccredit number(3) --课程学分)