1 CREATE OR REPLACE TRIGGER trigg_example
2 BEFORE INSERT OR UPDATE ON table_example
3 FOR EACH ROW
4 WHEN (new.no_line > 0)
5 DECLARE
6 evol_exemple number;
7 BEGIN
8 evol_exemple := :new.exemple - :old.exemple;
9 DBMS_OUTPUT.PUT_LINE(' evolution : ' || evol_exemple);
10 END;