--PL/SQL:参数游标的简单例子
procedure get_score
is
cursor student_no_list is
select student_no from student;
cur student_score(i_student_no in varchar2) is
select student_no,subject,score from score where student_no = i_student_no ;
begin
for rw in student_no_list loop
for rw1 in student_score(rw.student_no ) loop
dbms_output.put_line('学号:'||rw1.student_no_list );
dbms_output.put_line('科目:'||rw1.subject);
dbms_output.put_line('分数:'||rw1.score);
end loop;
end loop;
end get_score;
参数游标的简单例子
最新推荐文章于 2022-08-07 17:50:27 发布