可以的,不过只能在本过程中调用,在其他地方也是可以写的 !
create procedure or replace pro_test as
function aa () as
begin
.....
end;
begin
end;
create procedure or replace pro_test as
function aa () as
begin
.....
end;
begin
end;
AS
function a return integer is
begin
return 1;
end;
function b return integer is
begin
return 1;
end;
BEGIN IF CONDITION THEN
RETURN NUM1;
ELSE
RETURN NUM2;
END IF;
END;
return number
as
begin
if num=2 then
return num;
else return 1;
end if;
end aa;