Question: CREATE OR REPLACE TRIGGER TRG _ UPD _ BEF _ ROW _ EMPLOYEE BEFOR UPDATE ON EMPLOYEE FOR EACH ROW BEGIN IF :NEW.SALARY > 4

CREATE OR REPLACE TRIGGER TRG_UPD_BEF_ROW_EMPLOYEE
BEFOR UPDATE
ON EMPLOYEE
FOR EACH ROW
BEGIN
IF :NEW.SALARY>400
INSERT INTO EMPLOYEE_LESS_EARNER (NAME) VALUE (:NEW.NAME);
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!