Question: CREATE OR REPLACE TRIGGER TRG _ UPD _ BEF _ ROW _ EMPLOYEE AFTER INSERT OR DELETE ON EMPLOYEE BEGIN INSERT INTO EMPLOYEE _ LESS

CREATE OR REPLACE TRIGGER TRG_UPD_BEF_ROW_EMPLOYEE
AFTER INSERT OR DELETE
ON EMPLOYEE
BEGIN
INSERT INTO EMPLOYEE_LESS_EARNER (COMMENT) VALUE ('DATA HAS CHANGED');
END IF;
END;
Following SQL is run against the EMPLOYEE table
UPDATE EMPLOYEE SET EMP_SALARY =500;
This results in updating 10 rows in EMPLOYEE table. How many times will this trigger fire?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!