我想建个名为 student_grade 的过程,其中包括以下内容:
select xs.xh,xs.xm,kc.kcm,xs_kc.kc
where xs.xh=xs_kc.xh and xs_kc.kch=kc.kch;
我创建的时间总出错,请帮我写条完整可正确执行的语句,谢谢!
select xs.xh,xs.xm,kc.kcm,xs_kc.kc
where xs.xh=xs_kc.xh and xs_kc.kch=kc.kch;
我创建的时间总出错,请帮我写条完整可正确执行的语句,谢谢!
as
type stu_cur is ref cursor;
procedure student_grade(cur out stu_cur);
end;
/
create or replace package body student
as
procedure student_grade(cur out stu_cur)
as
begin
open cur for select xs.xh,xs.xm,kc.kcm,xs_kc.kc FROM xs,xs_kc,kc
where xs.xh=xs_kc.xh and xs_kc.kch=kc.kch;
end;
end;
/