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

CREATE OR REPLACE TRIGGER TRG_UPD_BEF_ROW_EMPLOYEE
AFTER INSERT OR UPDATE 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!

Q:

Hello, below are my SQL statements for Oracle. The bold statements are the ones that I am getting errors on. Then when I do the UPDATES they compile but still give an error If someone could look over...

Q:

CREATE OR REPLACE TRIGGER TRG _ UPD _ BEF _ ROW _ EMPLOYEE BEFOR UPDATE ON EMPLOYEE FOR EACH ROW BEGIN IF :NEW.SALARY > 4 0 0 INSERT INTO EMPLOYEE _ LESS _ EARNER ( NAME ) VALUE ( :NEW.NAME ) ; END...

Q:

1. What is ON DELETE CASCADE ? 2. Can a child's FK field have a different name than the parent's PK field? Provide examples. 3. What is referential integrity? How referential integrity rules are...

Q:

Q2(b) Given the following EMPLOYEE schema in which id is the primary key. EMPLOYEE( id , name , rank , salary , bonus ) i. Create a stored procedure named PRC_DELETE_EMP to delete a row of employee...

Q:

Problem 1 To create a trigger: when some records are deleted from the emp table, the deleted records are written into an employee history table(create the history table firstly). CREATE TABLE emp_his...

Q:

Please Use ORACLE SQL In this application, you will be adding/registering an item, updating it, and doing select statements. You get to pick what you are registering. It can be students, employees,...

Q:

I am using Oracle SQL Developer , and I am running into issues with this code- specifically Integrity Constraint errors. create table Employee(empID NUMBER, empFname VARCHAR2(20), empLname...

Q:

I am testing a trigger.I have below tables Employee and Sales. create table employee ( emp_id number(4), mgr_id number(4), duration number(4)); create table sales ( sales_id number(4),...

Q:

Q1. Create a trigger on the employees table. The trigger should skip all inserts whenever the salary of the employee to be added is less than the minimum salary of a current employee. For example, if...

Q:

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;...

Q:

Repeat Prob. 4-133 by assuming the piston is made of 8 kg of copper initially at the average temperature of the two gases on both sides.

Q:

Maintenance Equipment, Inc., would like to estimate costs associated with its sales personnel. Salespeople are paid a salary plus a commission. Commission rates vary among products and are based on...

Q:

What is the HPR for a share of stock that was purchase for $ 2 5 , sold for $ 2 7 and distributed $ 1 . 2 5 in dividends?What is the Div yield? Capital gain yield?

Q:

7 3 points Calculate two iterations of Newton s Method to approximate a zero of the function using the given initial guess f x x 3 x 1 4