Oracle 存储过程：计算员工总数

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;