Creation d'un trigger sql

 CREATE OR REPLACE TRIGGER trigg_example
 BEFORE INSERT OR UPDATE ON table_example
 FOR EACH ROW
 WHEN (new.no_line > 0)
 DECLARE
     evol_exemple number;
 BEGIN
     evol_exemple := :new.exemple  - :old.exemple;
     DBMS_OUTPUT.PUT_LINE('  evolution : ' || evol_exemple);
 END;

Source: sql.sh

Similar codes

1 vote165 views1 answer
Select last row from SQL Table
SQL
0 vote119 views1 answer
Oracle locked objects
SQL
2 votes122 views1 answer
Oracle apex list connected users
SQL
0 vote120 views1 answer
Power query case when
SQL
7 votes119 views6 answers
Group_concat mysql
SQL
21 votes166 views3 answers
Average sql
SQL
0 vote140 views1 answer
Sql server convert to guid
SQL
0 vote123 views1 answer
Adding conditions in MERGE statement in Oracle SQL for INSERT/UPDATE
SQL
0 vote155 views1 answer
Day of the week sqlite
SQL
0 vote127 views1 answer
How to export only procedures mysql
SQL