存储过程

--案例01：打印乘法小九九  http://blog.csdn.net/yangzhawen/article/details/7309535

create or replace procedure xjj

as

i integer;

j integer;

begin

   dbms_output.put_line(' 打印小九九   ');

    for i in 1..9 loop //范围为1到9

    for j in 1..9 loop

  ifi>=j then

   dbms_output.put_line(to_char(j) ||'*'||to_char(i) ||'='||to_char(i*j)||'  ');// ||为连接符

   end if;

   end loop;//结束第一个循环

dbms_output.put_line('    ');

end loop;//结束第二个循环

end;

 

oracle游标，存储过程，for循环，loop合一  http://www.cnblogs.com/sumsen/archive/2012/05/30/2525431.html

 

create or replace procedurelibsys.add_money(money out number)

as

cursor cur is select amount fromlibsys.money_record;

begin

money:=0;

for amounts in cur  //每次只能取一个或一行数据

loop

money:=money+amounts;

end loop;

end add_money;

 

 

实例讲解开发ORACLE存储过程http://tech.watchstor.com/backup-and-archiving-114322.htm

Oracle存储过程开发实例http://blog.sina.com.cn/s/blog_641145910100guwe.html