当前位置：首页 > SQL > ST数据库

ST数据库

王丛4年前 (2021-04-27)SQL798

1．基于ST数据库中的TeachTasksInfo表，创建存储过程InsertTeachTask，功能为根据插入信息中的学年、学期、教师编号和课程号等信息自动生成主键TeachTaskID，并插入一条记录。  
2．创建存储过程，将指定课程任务编号的学生成绩提升10%，如果已经超过100分，则为100分。存储过程的默认课程任务编号为：(2009-2010-1)-140173-04001。（重要）

set setveroutput on;  
create or replace procedure InsertTeachTask (v\_TeachTaskID char,v\_Cno char,v\_TeacherID char,v\_AcadeYear char,v\_Term char,v\_ExamMethod varchar,v\_Depart varchar,v\_TimeTable varchar)  
as  
 vs\_TeachTaskID char(26);  
 vs\_Cno char(6);  
 vs\_TeacherID char(5);  
 vs\_AcadeYear char(9);  
 vs\_Term char(1);  
 vs\_ExamMethod varchar(10);  
 vs\_Depart varchar(30);  
 vs\_TimeTable varchar(50);

begin   
 vs\_TeachTaskID:=v\_TeachTaskID;  
 vs\_Cno:= v\_Cno;  
 vs\_TeacherID:= v\_TeacherID;  
 vs\_AcadeYear:=v\_AcadeYear;  
 vs\_Term :=v\_Term;  
 vs\_ExamMethod := v\_ExamMethod;  
 vs\_Depart:=v\_Depart;  
 vs\_TimeTable :=v\_TimeTable;  
 insert into TeachTasksInfo(TeachTaskID, Cno, TeacherID, AcadeYear,Term,ExamMethod,Depart,TimeTable)values(vs\_TeachTaskID, vs\_Cno, vs\_TeacherID, vs\_AcadeYear,vs\_Term,vs\_ExamMethod,vs\_Depart,vs\_TimeTable);  
DBMS\_OUTPUT.PUT\_LINE('end join, please check...');  
end;

exec InsertTeachTask ('(2009-2010-7)-140173-04001','140173','04001','2009-2010','1','考试','计算机系','周二第3,4节{第1-20周}')