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

0 vote298 views1 answer
Find how many table doesn't contain column in mysql
SQL
-1 vote283 views2 answers
How to select the lowest values from table per client sql
SQL
0 vote278 views1 answer
Sub query in linq
SQL
1 vote300 views1 answer
Oracle truncate partition
SQL
0 vote274 views1 answer
Mysqldump don't drop table
SQL
0 vote273 views1 answer
Nueva tabla mysql
SQL
5 votes287 views3 answers
Mysql update field from one table to another
SQL
0 vote279 views1 answer
Psql use query result convert Decimal python numpy psycopg2
SQL
0 vote307 views1 answer
C# execute transact sql
SQL
3 votes301 views1 answer
Oracle list dates without weekends
SQL