create procedure count_num(in_sex in person.sex%type,out_num out number)as
v_number number(8);
begin
if in_sex='m' then
select count(*) into v_number from person where sex='m';
else
select count(*) into v_number from person where sex='w';
end if;
out_num:=v_number;
end count_num;
v_number number(8);
begin
if in_sex='m' then
select count(*) into v_number from person where sex='m';
else
select count(*) into v_number from person where sex='w';
end if;
out_num:=v_number;
end count_num;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货