SQL> declare
2 cursor c_student is
3 select major,first_name,last_name,department,course,grade
4
5 from students,registered_students where students.id=registered_students.stu
dent_id;
6
7 v_major students.major%type;
8 v_first_name students.first_name%type;
9 v_last_name students.last_name%type;
10 v_department registered_students.department%type;
11 v_course registered_students.course%type;
12 v_grade registered_students.grade%type;
13
14 begin
15 open c_student;
16 fetch c_student into v_major,v_first_name,v_last_name,v_department,v_course
,v_grade;
17 while c_student%found
18 loop
19 dbms_output.put_line(v_major||' '||v_first_name||' '||v_last_name||' '||v_d
epartment||' '||v_course||' '||v_grade);
20 fetch c_student into v_major,v_first_name,v_last_name,v_department,v_course
,v_grade;
21 end loop;
22 end;
23 /PL/SQL 过程已成功完成。问题:在第19行应该会显示输出的,但是为什么会没有输出了???
请教高手!!!
up。。------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
网上资源: http://tianlesoftware.download.csdn.net
相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
Q Q 群:62697716
set serveroutput on;