代码在视频课程中执行成功。为什么自己操作执行时报错?
在行: 2 上开始执行命令时出错 -
declare
cursor cdept is select dno,dname from dep;
pdno dep.dno%type;
pdname dep.dname%type;
cursor cgrade(coursename varchar2,depno number)
is select grade from sc where cno=(select cno from course where cname=coursename)
and sno in (select sno from student where dno=depno);
pgrade sc.grade%type;
count1 number;
count2 number;
count3 number;
avggrade number;
pcourseName VARCHAR2(3):='大学物理';
begin
open cdept;
loop
fetch cdept into pdno,pdname;
exit when cdept%notfound;
count1:=0; count2:=0; count3:=0;
select avg(grade) into avggrade from sc where cno=(select cno from course where cname=pcourseName)
and sno in (select sno from student where dno=pdno);
open cgrade(pcourseName,pdno);
loop
fetch cgrade into pgrade;
exit when cgrade%notfound;
if pgrade 60 and pgrade |
免责声明:本内容仅代表回答会员见解不代表天盟观点,请谨慎对待。
版权声明:作者保留权利,不代表天盟立场。
|
|
|
|