函数的学习与练习, 笔记为:
--函数
create or replace function fun1 return number
is
v_sum number(8);
begin
select sal*12+nvl(comm,0) into v_sum from emp where empno=&empno;
return v_sum;
end fun1;
/
select fun1 from dual;
---------------------------求和1~100
create or replace function fun2 return number
is
v_sum number(8):=0;
begin
for i in 1..100 loop
v_sum:=i+v_sum;
end loop;
return v_sum;
end fun2;
/
select fun2 from dual;
---------------------------带参函数求和1~100
create or replace function fun3(n in number) return number
is
v_sum number(8):=0;
begin
for i in 1..n loop
v_sum:=i+v_sum;
end loop;
return v_sum;
end fun3;
/
select fun3(100) from dual;