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

7 votes241 views1 answer
Sql server management studio turn on line numbers
SQL
0 vote244 views1 answer
CALCULATING MONTHS BETWEEN TWO DATES IN POSTGRESQL
SQL
0 vote232 views1 answer
Split string by comma in sql server
SQL
0 vote239 views1 answer
Choose only one for each distinct collumn regardless of other columns
SQL
5 votes233 views1 answer
Ignore duplicate rows in sqlite
SQL
0 vote268 views1 answer
SQLServerException.makeFromDatabaseError
SQL
0 vote227 views2 answers
How to save result of sqlite query in a table
SQL
0 vote242 views1 answer
Sql dmv to capture updates
SQL
19 votes233 views6 answers
What is mySQL
SQL
6 votes241 views2 answers
If not exists insert sql
SQL