GitHub

Ex. No: 5 Creating Triggers using PL/SQL

AIM: To create a Trigger using PL/SQL. CREATE OR REPLACE TRIGGER logging_sal_update 2 BEFORE UPDATE ON el 3 FOR EACH ROW 4 BEGIN 5 IF :OLD.salary != :NEW.salary THEN 6 INSERT INTO wages_log (empid, ...
GitHub

Ex. No: 5 Creating Triggers using PL/SQL

To create a Trigger using PL/SQL. UPDATE employee SET salary = 50000 WHERE empid = 1; UPDATE employee SET salary = 40000 WHERE empid = 2; SELECT * FROM employee; SELECT * FROM salary_log; ...