My issue
CREATE OR REPLACE TRIGGER update_department_salary
AFTER INSERT OR UPDATE ON employees
DECLARE
v_department VARCHAR2(50);
v_avg_salary INT;
BEGIN
– Delete existing records from department_salary table
DELETE FROM department_salary;
-- Insert new records into department_salary table
END;
/
My code
CREATE OR REPLACE TRIGGER update_department_salary
AFTER INSERT OR UPDATE ON employees
DECLARE
v_department VARCHAR2(50);
v_avg_salary INT;
BEGIN
-- Delete existing records from department_salary table
DELETE FROM department_salary;
-- Insert new records into department_salary table
END;
/
UPDATE employees
SET salary = 60000
WHERE emp_id = 103;
UPDATE employees
SET salary = 60000
WHERE emp_id = 105;
Select * from department_salary;
Learning course: Database management systems
Problem Link: Practice - Multiple table udpate in Database management systems