数据库练习建表脚本简化版_Oracle

2016-07-02 17:24:50  访问(2924) 赞(0) 踩(0)


相关下载：数据库练习建表脚本简化版_Oracle.zip     

-- 创建班级表 --

create table UTB_EXAM_CLASS

(

ID number not null primary key, -- 班级表 --

TheName varchar2(255) not null, -- 名称 --

EmClassTypeV integer not null, -- 班级类型（1:普通文科班；2:普通理科班；3:重点文科班；4:重点理科班）

CreateTime date default sysdate not null, -- 创建时间 --

UpdateTime date default sysdate not null -- 修改时间 --

);


--+ [表]UTB_EXAM_CLASS:班级表 |-- 

comment on table UTB_EXAM_CLASS is '班级表';


--+ ID:班级表 |-- 

comment on column UTB_EXAM_CLASS.ID is '班级表';


--+ TheName:名称 |-- 

comment on column UTB_EXAM_CLASS.TheName is '名称';


--+ EmClassTypeV:班级类型（1:普通文科班；2:普通理科班；3:重点文科班；4:重点理科班） |-- 

comment on column UTB_EXAM_CLASS.EmClassTypeV is '班级类型（1:普通文科班；2:普通理科班；3:重点文科班；4:重点理科班）';


--+ CreateTime:创建时间 |-- 

comment on column UTB_EXAM_CLASS.CreateTime is '创建时间';


--+ UpdateTime:修改时间 |-- 

comment on column UTB_EXAM_CLASS.UpdateTime is '修改时间';




-- 创建[表格:UTB_EXAM_CLASS] seq_exam_class -- 

CREATE SEQUENCE seq_exam_class

START WITH 1

INCREMENT BY 1

MINVALUE 1

NOMAXVALUE

NOCACHE 

NOCYCLE

NOORDER 

/






--+ 创建课程表(UTB_EXAM_COURSE) |--

create table UTB_EXAM_COURSE

(

ID number not null primary key, -- 课程表 --

TheName varchar2(255) not null, -- 名称 --

CreateTime date default sysdate not null, -- 创建时间 --

UpdateTime date default sysdate not null -- 修改时间 --

);


--+ [表]UTB_EXAM_COURSE:课程表 |-- 

comment on table UTB_EXAM_COURSE is '课程表';


--+ ID:课程表 |-- 

comment on column UTB_EXAM_COURSE.ID is '课程表';


--+ TheName:名称 |-- 

comment on column UTB_EXAM_COURSE.TheName is '名称';


--+ CreateTime:创建时间 |-- 

comment on column UTB_EXAM_COURSE.CreateTime is '创建时间';


--+ UpdateTime:修改时间 |-- 

comment on column UTB_EXAM_COURSE.UpdateTime is '修改时间';




-- 创建[表格:UTB_EXAM_COURSE] seq_exam_course -- 

CREATE SEQUENCE seq_exam_course

START WITH 1

INCREMENT BY 1

MINVALUE 1

NOMAXVALUE

NOCACHE 

NOCYCLE

NOORDER 

/




--+ 创建表(UTB_EXAM_PERIOD) |--

create table UTB_EXAM_PERIOD

(

ID number not null primary key, -- 学期 --

TheName varchar2(255) not null, -- 名称 --

StartDate date not null, -- 开始时间 --

EndDate date not null, -- 结束时间 --

CreateTime date default sysdate not null, -- 创建时间 --

UpdateTime date default sysdate not null -- 修改时间 --

);


--+ [表]UTB_EXAM_PERIOD:学期 |-- 

comment on table UTB_EXAM_PERIOD is '学期';


--+ ID:学期 |-- 

comment on column UTB_EXAM_PERIOD.ID is '学期';


--+ TheName:名称 |-- 

comment on column UTB_EXAM_PERIOD.TheName is '名称';


--+ StartDate:开始时间 |-- 

comment on column UTB_EXAM_PERIOD.StartDate is '开始时间';


--+ EndDate:结束时间 |-- 

comment on column UTB_EXAM_PERIOD.EndDate is '结束时间';


--+ CreateTime:创建时间 |-- 

comment on column UTB_EXAM_PERIOD.CreateTime is '创建时间';


--+ UpdateTime:修改时间 |-- 

comment on column UTB_EXAM_PERIOD.UpdateTime is '修改时间';




-- 创建[表格:UTB_EXAM_PERIOD] seq_exam_period -- 

CREATE SEQUENCE seq_exam_period

START WITH 1

INCREMENT BY 1

MINVALUE 1

NOMAXVALUE

NOCACHE 

NOCYCLE

NOORDER 

/



--+ 创建表(UTB_EXAM_STUDENT) |--

create table UTB_EXAM_STUDENT

(

ID number not null primary key, -- 学生 --

TheName varchar2(255) not null, -- 名称 --

ClassId number not null, -- 所在班级 --

foreign key(ClassId) references UTB_EXAM_CLASS(ID),

CreateTime date default sysdate not null, -- 创建时间 --

UpdateTime date default sysdate not null -- 修改时间 --

);


--+ [表]UTB_EXAM_STUDENT:学生 |-- 

comment on table UTB_EXAM_STUDENT is '学生';


--+ ID:学生 |-- 

comment on column UTB_EXAM_STUDENT.ID is '学生';


--+ TheName:名称 |-- 

comment on column UTB_EXAM_STUDENT.TheName is '名称';


--+ ClassId:所在班级 |-- 

comment on column UTB_EXAM_STUDENT.ClassId is '所在班级';


--+ CreateTime:创建时间 |-- 

comment on column UTB_EXAM_STUDENT.CreateTime is '创建时间';


--+ UpdateTime:修改时间 |-- 

comment on column UTB_EXAM_STUDENT.UpdateTime is '修改时间';




-- 创建[表格:UTB_EXAM_STUDENT] seq_exam_student -- 

CREATE SEQUENCE seq_exam_student

START WITH 1

INCREMENT BY 1

MINVALUE 1

NOMAXVALUE

NOCACHE 

NOCYCLE

NOORDER 

/



--+ 创建表(UTB_EXAM_TEACHER) |--

create table UTB_EXAM_TEACHER

(

ID number not null primary key, -- 教师 --

TheName varchar2(255) not null, -- 名称 --

CreateTime date default sysdate not null, -- 创建时间 --

UpdateTime date default sysdate not null -- 修改时间 --

);


--+ [表]UTB_EXAM_TEACHER:教师 |-- 

comment on table UTB_EXAM_TEACHER is '教师';


--+ ID:教师 |-- 

comment on column UTB_EXAM_TEACHER.ID is '教师';


--+ TheName:名称 |-- 

comment on column UTB_EXAM_TEACHER.TheName is '名称';


--+ CreateTime:创建时间 |-- 

comment on column UTB_EXAM_TEACHER.CreateTime is '创建时间';


--+ UpdateTime:修改时间 |-- 

comment on column UTB_EXAM_TEACHER.UpdateTime is '修改时间';




-- 创建[表格:UTB_EXAM_TEACHER] seq_exam_teacher -- 

CREATE SEQUENCE seq_exam_teacher

START WITH 1

INCREMENT BY 1

MINVALUE 1

NOMAXVALUE

NOCACHE 

NOCYCLE

NOORDER 

/




--+ 创建表(UTB_EXAM_SCORE) |--

create table UTB_EXAM_SCORE

(

ID number not null primary key, -- 成绩 --

StudentId number not null, -- 学生 --

foreign key(StudentId) references UTB_EXAM_STUDENT(ID),

TeacherId number not null, -- 教师 --

foreign key(TeacherId) references UTB_EXAM_TEACHER(ID),

PeriodId number not null, -- 学期 --

foreign key(PeriodId) references UTB_EXAM_PERIOD(ID),

CourseId number not null, -- 课程 --

foreign key(CourseId) references UTB_EXAM_COURSE(ID),

Score number(18, 2), -- 得分 --

CreateTime date default sysdate not null, -- 创建时间 --

UpdateTime date default sysdate not null -- 修改时间 --

);


--+ [表]UTB_EXAM_SCORE:成绩 |-- 

comment on table UTB_EXAM_SCORE is '成绩';


--+ ID:成绩 |-- 

comment on column UTB_EXAM_SCORE.ID is '成绩';


--+ StudentId:学生 |-- 

comment on column UTB_EXAM_SCORE.StudentId is '学生';


--+ TeacherId:教师 |-- 

comment on column UTB_EXAM_SCORE.TeacherId is '教师';


--+ PeriodId:学期 |-- 

comment on column UTB_EXAM_SCORE.PeriodId is '学期';


--+ CourseId:课程 |-- 

comment on column UTB_EXAM_SCORE.CourseId is '课程';


--+ Score:得分 |-- 

comment on column UTB_EXAM_SCORE.Score is '得分';


--+ CreateTime:创建时间 |-- 

comment on column UTB_EXAM_SCORE.CreateTime is '创建时间';


--+ UpdateTime:修改时间 |-- 

comment on column UTB_EXAM_SCORE.UpdateTime is '修改时间';




-- 创建[表格:UTB_EXAM_SCORE] seq_exam_score -- 

CREATE SEQUENCE seq_exam_score

START WITH 1

INCREMENT BY 1

MINVALUE 1

NOMAXVALUE

NOCACHE 

NOCYCLE

NOORDER 

/


--| insert data |--


--+ 新增表记录(UTB_EXAM_CLASS) |--

insert into UTB_EXAM_CLASS (ID,TheName,EmClassTypeV,CreateTime,UpdateTime) values (1,'一班',1,sysdate,sysdate) ;

insert into UTB_EXAM_CLASS (ID,TheName,EmClassTypeV,CreateTime,UpdateTime) values (2,'二班',2,sysdate,sysdate) ;

insert into UTB_EXAM_CLASS (ID,TheName,EmClassTypeV,CreateTime,UpdateTime) values (3,'三班',3,sysdate,sysdate) ;

insert into UTB_EXAM_CLASS (ID,TheName,EmClassTypeV,CreateTime,UpdateTime) values (4,'四班',4,sysdate,sysdate) ;




--+ 新增表记录(UTB_EXAM_COURSE) |--

insert into UTB_EXAM_COURSE (ID,TheName,CreateTime,UpdateTime) values (1,'语文',sysdate,sysdate) ;

insert into UTB_EXAM_COURSE (ID,TheName,CreateTime,UpdateTime) values (2,'数学',sysdate,sysdate) ;

insert into UTB_EXAM_COURSE (ID,TheName,CreateTime,UpdateTime) values (3,'物理',sysdate,sysdate) ;

insert into UTB_EXAM_COURSE (ID,TheName,CreateTime,UpdateTime) values (4,'历史',sysdate,sysdate) ;




--+ 新增表记录(UTB_EXAM_PERIOD) |--

insert into UTB_EXAM_PERIOD (ID,TheName,StartDate,EndDate,CreateTime,UpdateTime) values (1,'第一学期',to_date('2012-09-01','yyyy-mm-dd'),to_date('2013-01-31','yyyy-mm-dd'), sysdate, sysdate) ;

insert into UTB_EXAM_PERIOD (ID,TheName,StartDate,EndDate,CreateTime,UpdateTime) values (2,'第二学期',to_date('2013-03-01','yyyy-mm-dd'),to_date('2013-06-30','yyyy-mm-dd'), sysdate, sysdate) ;

insert into UTB_EXAM_PERIOD (ID,TheName,StartDate,EndDate,CreateTime,UpdateTime) values (3,'第三学期',to_date('2013-09-01','yyyy-mm-dd'),to_date('2014-01-31','yyyy-mm-dd'), sysdate, sysdate) ;

insert into UTB_EXAM_PERIOD (ID,TheName,StartDate,EndDate,CreateTime,UpdateTime) values (4,'第四学期',to_date('2014-03-01','yyyy-mm-dd'),to_date('2014-06-30','yyyy-mm-dd'), sysdate, sysdate) ;



--+ 新增表记录(UTB_EXAM_STUDENT) |--

insert into UTB_EXAM_STUDENT (ID,TheName,ClassId,CreateTime,UpdateTime) values (4,'杨彬',1,sysdate,sysdate) ;

insert into UTB_EXAM_STUDENT (ID,TheName,ClassId,CreateTime,UpdateTime) values (5,'姜丽君',2,sysdate,sysdate) ;

insert into UTB_EXAM_STUDENT (ID,TheName,ClassId,CreateTime,UpdateTime) values (6,'李静',3,sysdate,sysdate) ;

insert into UTB_EXAM_STUDENT (ID,TheName,ClassId,CreateTime,UpdateTime) values (8,'杨俭',1,sysdate,sysdate) ;

insert into UTB_EXAM_STUDENT (ID,TheName,ClassId,CreateTime,UpdateTime) values (9,'姜丽君',2,sysdate,sysdate) ;

insert into UTB_EXAM_STUDENT (ID,TheName,ClassId,CreateTime,UpdateTime) values (10,'李静',3,sysdate,sysdate) ;

insert into UTB_EXAM_STUDENT (ID,TheName,ClassId,CreateTime,UpdateTime) values (11,'田振坤',4,sysdate,sysdate) ;

insert into UTB_EXAM_STUDENT (ID,TheName,ClassId,CreateTime,UpdateTime) values (12,'胡惠平',1,sysdate,sysdate) ;

insert into UTB_EXAM_STUDENT (ID,TheName,ClassId,CreateTime,UpdateTime) values (13,'闫东升',2,sysdate,sysdate) ;

insert into UTB_EXAM_STUDENT (ID,TheName,ClassId,CreateTime,UpdateTime) values (14,'孙红新',3,sysdate,sysdate) ;

insert into UTB_EXAM_STUDENT (ID,TheName,ClassId,CreateTime,UpdateTime) values (15,'刘林',4,sysdate,sysdate) ;

insert into UTB_EXAM_STUDENT (ID,TheName,ClassId,CreateTime,UpdateTime) values (16,'张耀伟',1,sysdate,sysdate) ;

insert into UTB_EXAM_STUDENT (ID,TheName,ClassId,CreateTime,UpdateTime) values (17,'郭立民',2,sysdate,sysdate) ;

insert into UTB_EXAM_STUDENT (ID,TheName,ClassId,CreateTime,UpdateTime) values (18,'罗列',3,sysdate,sysdate) ;

insert into UTB_EXAM_STUDENT (ID,TheName,ClassId,CreateTime,UpdateTime) values (19,'区焯林',4,sysdate,sysdate) ;

insert into UTB_EXAM_STUDENT (ID,TheName,ClassId,CreateTime,UpdateTime) values (20,'徐晓创',1,sysdate,sysdate) ;

insert into UTB_EXAM_STUDENT (ID,TheName,ClassId,CreateTime,UpdateTime) values (21,'王明和',2,sysdate,sysdate) ;

insert into UTB_EXAM_STUDENT (ID,TheName,ClassId,CreateTime,UpdateTime) values (22,'杨原志',3,sysdate,sysdate) ;

insert into UTB_EXAM_STUDENT (ID,TheName,ClassId,CreateTime,UpdateTime) values (23,'汪媛',4,sysdate,sysdate) ;

insert into UTB_EXAM_STUDENT (ID,TheName,ClassId,CreateTime,UpdateTime) values (24,'唐松',1,sysdate,sysdate) ;

insert into UTB_EXAM_STUDENT (ID,TheName,ClassId,CreateTime,UpdateTime) values (25,'宋文静',2,sysdate,sysdate) ;

insert into UTB_EXAM_STUDENT (ID,TheName,ClassId,CreateTime,UpdateTime) values (26,'孙波',3,sysdate,sysdate) ;

insert into UTB_EXAM_STUDENT (ID,TheName,ClassId,CreateTime,UpdateTime) values (27,'辛年香',4,sysdate,sysdate) ;

insert into UTB_EXAM_STUDENT (ID,TheName,ClassId,CreateTime,UpdateTime) values (28,'毛钟红',1,sysdate,sysdate) ;

insert into UTB_EXAM_STUDENT (ID,TheName,ClassId,CreateTime,UpdateTime) values (29,'邱苇',2,sysdate,sysdate) ;

insert into UTB_EXAM_STUDENT (ID,TheName,ClassId,CreateTime,UpdateTime) values (30,'黎晖',3,sysdate,sysdate) ;

insert into UTB_EXAM_STUDENT (ID,TheName,ClassId,CreateTime,UpdateTime) values (31,'陈树思',4,sysdate,sysdate) ;

insert into UTB_EXAM_STUDENT (ID,TheName,ClassId,CreateTime,UpdateTime) values (32,'方焱松',1,sysdate,sysdate) ;

insert into UTB_EXAM_STUDENT (ID,TheName,ClassId,CreateTime,UpdateTime) values (33,'张晓',2,sysdate,sysdate) ;

insert into UTB_EXAM_STUDENT (ID,TheName,ClassId,CreateTime,UpdateTime) values (34,'李刚',3,sysdate,sysdate) ;

insert into UTB_EXAM_STUDENT (ID,TheName,ClassId,CreateTime,UpdateTime) values (35,'鲜跃仲',4,sysdate,sysdate) ;

insert into UTB_EXAM_STUDENT (ID,TheName,ClassId,CreateTime,UpdateTime) values (36,'邱梦莹',1,sysdate,sysdate) ;

insert into UTB_EXAM_STUDENT (ID,TheName,ClassId,CreateTime,UpdateTime) values (37,'陈志鸿',2,sysdate,sysdate) ;

insert into UTB_EXAM_STUDENT (ID,TheName,ClassId,CreateTime,UpdateTime) values (38,'邓开喜',3,sysdate,sysdate) ;

insert into UTB_EXAM_STUDENT (ID,TheName,ClassId,CreateTime,UpdateTime) values (39,'何保华',4,sysdate,sysdate) ;

insert into UTB_EXAM_STUDENT (ID,TheName,ClassId,CreateTime,UpdateTime) values (40,'杨成才',1,sysdate,sysdate) ;

insert into UTB_EXAM_STUDENT (ID,TheName,ClassId,CreateTime,UpdateTime) values (41,'李健',2,sysdate,sysdate) ;

insert into UTB_EXAM_STUDENT (ID,TheName,ClassId,CreateTime,UpdateTime) values (42,'封科军',3,sysdate,sysdate) ;

insert into UTB_EXAM_STUDENT (ID,TheName,ClassId,CreateTime,UpdateTime) values (43,'褚浩男',4,sysdate,sysdate) ;




--+ 新增表记录(UTB_EXAM_TEACHER) |--

insert into UTB_EXAM_TEACHER (ID,TheName,CreateTime,UpdateTime) values (1,'陈老师',sysdate,sysdate) ;

insert into UTB_EXAM_TEACHER (ID,TheName,CreateTime,UpdateTime) values (2,'吴老师',sysdate,sysdate) ;

insert into UTB_EXAM_TEACHER (ID,TheName,CreateTime,UpdateTime) values (3,'王老师',sysdate,sysdate) ;

insert into UTB_EXAM_TEACHER (ID,TheName,CreateTime,UpdateTime) values (4,'杨老师',sysdate,sysdate) ;

insert into UTB_EXAM_TEACHER (ID,TheName,CreateTime,UpdateTime) values (6,'李老师',sysdate,sysdate) ;




--+ 新增表记录(UTB_EXAM_SCORE) |--

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (1,4,1,1,1,95.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (2,8,1,1,1,85.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (3,12,1,1,1,96.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (4,16,1,1,1,16.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (5,20,1,1,1,26.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (6,24,1,1,1,26.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (7,28,1,1,1,98.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (8,32,1,1,1,17.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (9,36,1,1,1,5.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (10,40,1,1,1,71.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (61,5,1,1,1,38.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (62,9,1,1,1,34.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (63,13,1,1,1,56.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (64,17,1,1,1,55.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (65,21,1,1,1,35.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (66,25,1,1,1,2.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (67,29,1,1,1,32.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (68,33,1,1,1,14.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (69,37,1,1,1,18.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (70,41,1,1,1,48.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (120,6,6,1,1,91.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (121,10,6,1,1,32.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (122,18,6,1,1,22.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (123,22,6,1,1,33.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (124,26,6,1,1,47.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (125,30,6,1,1,39.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (126,34,6,1,1,93.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (127,38,6,1,1,12.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (128,42,6,1,1,81.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (177,11,6,1,1,96.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (178,15,6,1,1,52.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (179,19,6,1,1,45.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (180,23,6,1,1,88.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (181,27,6,1,1,23.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (182,31,6,1,1,0.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (183,35,6,1,1,83.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (184,39,6,1,1,17.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (185,43,6,1,1,98.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (235,4,3,2,2,17.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (236,8,3,2,2,19.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (237,12,3,2,2,11.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (238,16,3,2,2,58.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (239,20,3,2,2,28.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (240,24,3,2,2,35.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (241,28,3,2,2,2.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (242,32,3,2,2,62.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (243,36,3,2,2,38.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (244,40,3,2,2,95.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (295,5,3,2,2,21.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (296,9,3,2,2,72.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (297,13,3,2,2,88.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (298,17,3,2,2,11.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (299,21,3,2,2,86.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (300,25,3,2,2,50.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (301,29,3,2,2,18.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (302,33,3,2,2,96.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (303,37,3,2,2,51.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (304,41,3,2,2,91.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (355,6,4,2,2,58.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (356,10,4,2,2,84.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (357,14,4,2,2,23.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (358,18,4,2,2,20.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (359,22,4,2,2,27.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (360,26,4,2,2,56.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (361,30,4,2,2,82.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (362,34,4,2,2,52.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (363,38,4,2,2,81.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (364,42,4,2,2,48.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (414,11,4,2,2,98.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (415,15,4,2,2,80.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (416,19,4,2,2,34.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (417,23,4,2,2,22.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (418,27,4,2,2,31.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (419,31,4,2,2,25.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (420,35,4,2,2,86.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (421,39,4,2,2,70.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (422,43,4,2,2,43.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (472,4,1,3,3,20.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (473,8,1,3,3,0.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (474,12,1,3,3,51.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (475,16,1,3,3,16.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (476,20,1,3,3,23.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (477,24,1,3,3,86.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (478,28,1,3,3,52.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (479,32,1,3,3,29.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (480,36,1,3,3,59.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (481,40,1,3,3,14.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (531,5,2,3,3,52.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (532,9,2,3,3,84.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (533,13,2,3,3,70.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (534,17,2,3,3,58.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (535,21,2,3,3,98.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (536,25,2,3,3,58.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (537,29,2,3,3,84.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (538,33,2,3,3,38.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (539,37,2,3,3,75.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (540,41,2,3,3,16.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (589,6,1,3,3,53.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (590,10,1,3,3,56.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (591,14,1,3,3,48.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (592,18,1,3,3,25.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (593,22,1,3,3,43.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (594,26,1,3,3,29.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (595,30,1,3,3,49.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (596,34,1,3,3,69.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (597,38,1,3,3,62.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (598,42,1,3,3,31.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (647,11,2,3,3,54.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (648,15,2,3,3,95.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (649,19,2,3,3,33.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (650,23,2,3,3,36.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (651,27,2,3,3,7.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (652,31,2,3,3,17.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (653,35,2,3,3,38.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (654,39,2,3,3,22.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (655,43,2,3,3,42.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (705,4,3,4,4,52.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (706,8,3,4,4,1.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (707,12,3,4,4,20.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (708,16,3,4,4,79.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (709,20,3,4,4,95.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (710,24,3,4,4,30.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (711,28,3,4,4,44.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (712,32,3,4,4,23.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (713,36,3,4,4,69.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (714,40,3,4,4,67.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (765,5,4,4,4,24.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (766,9,4,4,4,22.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (767,13,4,4,4,45.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (768,17,4,4,4,88.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (769,21,4,4,4,16.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (770,25,4,4,4,24.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (771,29,4,4,4,61.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (772,33,4,4,4,9.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (773,37,4,4,4,69.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (774,41,4,4,4,89.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (825,6,3,4,4,61.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (826,10,3,4,4,82.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (827,14,3,4,4,42.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (828,18,3,4,4,47.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (829,22,3,4,4,10.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (830,26,3,4,4,31.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (831,30,3,4,4,53.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (832,34,3,4,4,42.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (833,38,3,4,4,27.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (834,42,3,4,4,4.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (883,11,4,4,4,35.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (884,15,4,4,4,91.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (885,19,4,4,4,65.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (886,23,4,4,4,40.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (887,27,4,4,4,86.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (888,31,4,4,4,25.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (889,35,4,4,4,41.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (890,39,4,4,4,98.00,sysdate,sysdate) ;

insert into UTB_EXAM_SCORE (ID,StudentId,TeacherId,PeriodId,CourseId,Score,CreateTime,UpdateTime) values (891,43,4,4,4,7.00,sysdate,sysdate) ;



标签：数据库练习建表脚本简化版_Oracle 

上一条：

下一条：


 

相关评论

评论加载中……
 

发表评论

类型：
内容：
  (Alt+Enter)
 
  ┈全部┈  
 
（显示默认分类）