Breaking News: Grepper is joining You.com. Read the official announcement!

plsql triggers

Proton answered on March 23, 2022 Popularity 9/10 Helpfulness 4/10

answer plsql triggers

plsql triggers

Comment

CREATE OR REPLACE TRIGGER display_salary_changes 
BEFORE DELETE OR INSERT OR UPDATE ON customers 
FOR EACH ROW 
WHEN (NEW.ID > 0) 
DECLARE 
   sal_diff number; 
BEGIN 
   sal_diff := :NEW.salary  - :OLD.salary; 
   dbms_output.put_line('Old salary: ' || :OLD.salary); 
   dbms_output.put_line('New salary: ' || :NEW.salary); 
   dbms_output.put_line('Salary difference: ' || sal_diff); 
END; 
/

Popularity 9/10 Helpfulness 4/10 Language sql

Source: www.tutorialspoint.com

Tags: plsql sql triggers

Link to this answer
Share Copy Link