create procedure pro(p_num out number) as begin select count(1) into p_num from aa; end; /declare num number; begin pro(num); dbms_output.put_line(num); end; /
存储过程没有返回值,但可以传递OUT 想用返回值,写个存储函数吧!
当然可以,存储过程返指function和procedure。 beckhambobo(beckham)是可以的。 另外,可以用function create function pro return number as result number(8); begin select count(1) into p_num from aa; return(result); end; /
as
begin
select count(1) into p_num from aa;
end;
/declare
num number;
begin
pro(num);
dbms_output.put_line(num);
end;
/
想用返回值,写个存储函数吧!
beckhambobo(beckham)是可以的。
另外,可以用function
create function pro return number
as
result number(8);
begin
select count(1) into p_num from aa;
return(result);
end;
/