一、存储过程示例一
create or replace procedure my_proc1
is
stu student%rowtype;
cursor stu_cur is select * from student;
begin
if not stu_cur%isopen then
open stu_cur;
end if;
loop
fetch stu_cur into stu;
exit when stu_cur%notfound;
dbms_output.put_line(stu.stu_name);
exit when stu_cur%rowcount>10;
end loop;
close stu_cur;
end;
二．开发一个存储过程，接收学生编号和学生姓名两个输入参
数，将指定编号的学生姓名改为传入的姓名。
create procedure my_proc2
(
stuid varchar2,
stuname varchar2
)
as
begin
update student set stu_name=stuname where stu_id=stuid;
commit;
end my_proc2;
三．开发一个存储过程，查询指定学号的学员姓名。
create or replace procedure my_proc3
(stuid in student.stu_id%type,stuname out student.stu_name%type)
as
begin
select s.stu_name into stuname from student s where
s.stu_id=stuid;
end;
declare
stuname student.stu_name%type;
begin
剩余7页未读，继续阅读
资源评论
