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 vote222 views1 answer
Sqlalchemy sequence postgresql
SQL
24 votes185 views5 answers
Sql reset auto increment
SQL
9 votes170 views1 answer
Mysql check date range
SQL
0 vote319 views1 answer
Android sqlite add column if not exists
SQL
0 vote194 views1 answer
Sql count more than 1
SQL
0 vote234 views1 answer
How to find unique element in sql
SQL
0 vote184 views1 answer
Services.AddDbContext DataSource Sqlite
SQL
5 votes200 views1 answer
Oracle list days between two dates
SQL
2 votes174 views2 answers
Join update query in sql
SQL
0 vote180 views1 answer
Inserting data into different tables at once in oracle sql
SQL