--PL/SQL:游标的简单例子
procedure get_student
is
--在此处声明
cursor student_list is
select student_no,student_name,student_phone from student;
begin
for rw in student loop
dbms_output.put_line('学号:'||rw.student_no);
dbms_output.put_line('姓名:'||rw.student_name);
dbms_output.put_line('电话:'||rw.student_phone );
end loop;
end get_student;
游标的简单例子
最新推荐文章于 2020-05-07 15:55:59 发布