成绩管理系统存储过程设计源代码.docxVIP

成绩管理系统存储过程设计源代码 create or replace procedure p_insert_student( id t_student.stuid%type, name t_student.stuname%type, sex t_student.sex%type) is begin insert into t_student values(id,name,sex); end; / exec p_insert_student(1,Tai,男‘); exec p_insert_student(2,Bakham,女‘); exec p_insert_student(3，’heibi‘，’女‘); insert into t_course values(1,微机原理,‘一’,5.0); insert into t_course values(2,数据库概论,二，4.5）； insert into t_course values(3,计算机网络,第三学期,5.5); insert into t_selcour values(1,1,85,5); insert into t_selcour values(1,3,66); insert into t_selcour values(1,2,88); insert into t_teacour values(1,1,太原理工