Процедура удаления записи по id работника

create or replace procedure remove_emp(employee_id NUMBER) as

total_emp NUMBER;

begin

delete from employees

where employees.employee_id = remove_emp.employee_id;

total_emp := total_emp - 1;

end;