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 vote202 views1 answer
Replace content value from old to new sql
SQL
1 vote206 views1 answer
Sql into vs insert into
SQL
5 votes237 views1 answer
Ascending order and where in sql
SQL
0 vote189 views1 answer
Mysql autoincrement valor inicial
SQL
0 vote194 views1 answer
Soql more than today
SQL
0 vote190 views1 answer
Teller stamp , bmo , PDF
SQL
0 vote185 views1 answer
Postgres create database if not exists
SQL
-2 votes209 views1 answer
No module named '_sqlite3
SQL
0 vote192 views1 answer
How to add boolean column in postgresql
SQL
0 vote249 views1 answer
Set Mamp mysql globally
SQL