DECLARE

CURSOR c_employee IS

SELECT e.employee_id, d.department_id, d.department_name, e.job_id, e.salary
FROM employees e

INNER JOIN departments d ON e.department_id = d.department_id

WHERE d.department_name IN ('Marketing', 'Administration')

OR e.job_id LIKE '%Clerk%';

BEGIN

FOR employee IN c_employee LOOP

IF employee.department_name = 'Marketing' THEN
UPDATE employees

SET salary = salary + 100

WHERE employee_id = employee. employee_id;
ELSIF employee.department_name = ‘Administration’ THEN
UPDATE employees

SET salary = salary + 150

WHERE employee_id = employee. employee_id;

ELSE

DELETE FROM employees

WHERE employee_id = employee. employee_id;

END IF;

END LOOP;

End;
                                
                            

Paste Hosted With By Wklejamy.pl