存储过程

create or replace procedure get_user_count(sex_id in Number,user_count out number)
is
begin
IF sex_id=0 THEN
SELECT COUNT(*) into  user_count FROM p_user WHERE p_user.sex='女';
ELSE
SELECT COUNT(*) into  user_count FROM  p_user WHERE p_user.sex='男';
END IF;
end;

调用存储过程:

DECLARE
    salary NUMBER(10);
begin
   get_user_count(1,salary);
   DBMS_OUTPUT.PUT_LINE(salary);
end;