- --新建表空间
- create tablespace itsvse
- datafile 'd:\itsvse.dbf'
- size 10m;
- --新建用户
- create user itsvse
- identified by 123;
- --授权用户itsvse连接
- grant connect to itsvse;
- --授权用户使用资源
- grant resource to itsvse;
- --新建学生信息表
- create table stuInfo
- (
- stuid number primary key,
- stuname varchar(10) not null,
- stusex varchar(2) check (stusex='男' or stusex='女'),
- stubir date
- );
- --新建课程信息表
- create table subInfo
- (
- subid number primary key,
- subname varchar(20) not null
- );
- --新建分类信息表
- create table scoreInfo
- (
- scoreid number primary key,
- scorexh number references stuinfo(stuid),
- scoresubid number references subInfo(subid),
- score number check (score>=0 or score <=100)
- );
- --向学生表插入数据
- insert into stuInfo values(1,'张山','男',to_date('2005-1-2','yyyy-mm-dd'));
- insert into stuInfo values(2,'历史','男',to_date('2001-3-6','yyyy-mm-dd'));
- insert into stuInfo values(3,'技术','女',to_date('1995-8-2','yyyy-mm-dd'));
- insert into stuInfo values(4,'张山','男',to_date('2006-1-22','yyyy-mm-dd'));
- insert into stuInfo values(5,'说道','女',to_date('2013-10-2','yyyy-mm-dd'));
- insert into stuInfo values(6,'虽然','男',to_date('1996-10-20','yyyy-mm-dd'));
- insert into stuInfo values(7,'谈一谈','女',to_date('2005-1-2','yyyy-mm-dd'));
- insert into stuInfo values(8,'一样','女',to_date('2005-1-2','yyyy-mm-dd'));
- insert into stuInfo values(9,'方法','男',to_date('2006-6-6','yyyy-mm-dd'));
- insert into stuInfo values(10,'尺寸','男',to_date('2008-8-8','yyyy-mm-dd'));
- --向课程信息表插入数据
- insert into subinfo values(1,'数据库');
- insert into subinfo values(2,'java');
- insert into subinfo values(3,'web开发');
- insert into subinfo values(4,'linux维护');
- insert into subinfo values(5,'安全维护');
- --向分类信息表插入数据
- insert into scoreInfo values(1,1,2,50);
- insert into scoreInfo values(2,1,3,70);
- insert into scoreInfo values(3,2,1,100);
- insert into scoreInfo values(4,3,1,80);
- insert into scoreInfo values(5,1,1,60);
|
Publicado en 6/3/2015 15:45:55
|
|
|
|
Publicado en 12/3/2015 10:27:24
