全文预览

oracle数据库课程设计报告学生成绩管理系统

上传者:upcfxx |  格式:doc  |  页数:25 |  大小:109KB

文档介绍
n others then s_state_values:=1;Рmit;Рend ;Р/Рcreate or replace procedure c_insert_cs(Рc_cs_class in cs.cs_class%type,Рc_state_values out number)РasРbeginРselect count(*) into c_state_values from csРwhere cs_class=c_cs_class;Рend ;Р/Рcreate or replace procedure p_insert_sub(Рp_sub_subject in sub.sub_subject%type,Рp_sub_teacher_name in sub.sub_teacher_name%type,Рs_state_values out number)РasРbeginРinsert into sub(sub_subject,sub_teacher_name)Рvalues(p_sub_subject, p_sub_teacher_name);Рif sql%rowcount=1Рthen s_state_values:=0;Рend if;Рe*ceptionР?when others then s_state_values:=1;Рmit;Рend;Р/Рcreate or replace procedure c_insert_sub(Рc_sub_subject in sub.sub_subject%type,Рc_state_values out number)РasРbeginРselect count(*) into c_state_values from subРwhere sub_subject=c_sub_subject;Рend ;Р/

收藏

分享

举报
下载此文档