human使用orcl数据库创建一个显示雇员总人数的存储过程emp_count

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