Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE PROCEDURE remove_emp (employee_id NUMBER) AS
- tot_emps NUMBER;
- BEGIN
- DELETE FROM employees
- WHERE employees.employee_id = remove_emp.employee_id;
- tot_emps := tot_emps - 1;
- END;
- /
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement