human 使用oracle创建一个显示雇员总人数的存储过程emp_count并执行该存储过程。;

CREATE OR REPLACE PROCEDURE emp_count AS emp_total NUMBER; BEGIN SELECT COUNT(*) INTO emp_total FROM employees; DBMS_OUTPUT.PUT_LINE('Total number of employees: ' || emp_total); END; /

EXECUTE emp_count;