return number using function
717727Oct 22 2010 — edited Oct 25 2010HOw I can return number using function.
Here is my procedure but don't like into variable name or setting up as variable..........
create or replace function Calculate_number(
number1 IN number,
number2 IN number )
return number Is
begin
declare
result number;
select number1+number2 into result from dual;
return(Result);
end ;