Oracle初探（七）

函数的学习与练习， 笔记为：

--函数

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;