2018-06-03T15:42:18.4240000002018-07-26T23:13:54.615000000PT4H8M32S13LibreOffice/5.4.3.2$Windows_x86 LibreOffice_project/92a7159f7e4af62137622921e809f8546db437e5 -1296 -8747 52107 26026 view1 true false true true false false false false true 1500 false //////////////////////////////////////////8= //////////////////////////////////////////8= false true true 0 0 true true true 4 0 -1081 -512 35307 27398 1000 1000 100 100 100 1 100 1 false 1500 true false true $(inst)/share/palette%3B$(user)/config/standard.sob 0 $(inst)/share/palette%3B$(user)/config/standard.soc $(inst)/share/palette%3B$(user)/config/standard.sod 1250 false en US $(inst)/share/palette%3B$(user)/config/standard.sog $(inst)/share/palette%3B$(user)/config/standard.soh false false true true false false true false false false $(inst)/share/palette%3B$(user)/config/standard.soe false 3 4 false 0 low-resolution false 1 1 true UPDATE Department SET budget = budget + 1000 WHERE budget <= 5000; Department Name Budget City Math 2300 Boston Comp 9999 Boston Phys 5000 New York Math 8000 Atlanta Biol 4500 Boston CREATE OR REPLACE TRIGGER UpdateDepartment AFTER UPDATE ON DEPARTMENT FOR EACH ROW -- Row triggers must have FOR EACH ROW clause! WHEN (NEW.city = ’Boston’)-- Condition applies only to row trigger! BEGIN INSERT INTO DEPTTRACE VALUES (’UPDATE’,SYSDATE, :NEW.name,:NEW.budget,:NEW.city, :OLD.name,:OLD.budget,:OLD.city); END;