creation d 27un trigger sql

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;