求救啊!!!PLS-00428: 在此 SELECT 语句中缺少 INTO 子句 declare
totalcourgrade real;
begin
totalcourgrade := GetCourseGrade('S07080101');
select tb_grade.stuid 学号,stuname 姓名,sum(coursegrade) 已获学分 from tb_grade,tb_student where tb_student.stuid = tb_grade.stuid
group by tb_grade.stuid,stuname;
dbms_output.put_line(totalcourgrade);
end;
出现以下错误:
select tb_grade.stuid 学号,stuname 姓名,sum(coursegrade) 已获学分 from tb_grade,tb_student where tb_student.stuid = tb_grade.stuid
*
BEGIN
FOR cc IN (SELECT * FROM tb_student) LOOP
totalcourgrade := GetCourseGrade(cc.stuid);
SELECT tb_grade.stuid, stuname, SUM(coursegrade)
INTO v_id, v_name, v_score
FROM tb_grade, tb_student
WHERE tb_student.stuid = tb_grade.stuid AND
tb_student.stuid = cc.stuid;