编写函数
create or replace function func_add(num1 in number,num2 in number)
return number is r number(3);num3 number(3);
begin
num3:=num1+num2;
r:=num3;
return(r);
end;
调用函数:
declare
num1 number;
num2 number;
num3 number;
begin
num1:=12;
num2:=3;
num3:=func_add(num1,num2);
dbms_output.put_line(num3);
end;