创建一个存储过程，接受2个月薪，利用传出参数返回月薪介于这2个月薪之间的人数。...

create or replace procedure p1(p_sal1 number,p_sal2 number,p_con out number)
is
begin
select count(*) into p_con from emp
where sal between p_sal1 and p_sal2;
end;

/

declare
v_count number(2);
begin
p1(1000,3000,v_count);
dbms_output.put_line(v_count);
end;

转载于:https://www.cnblogs.com/y-zz/p/8010666.html