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 vote139 views1 answer
How to check replication lag in mySQL
SQL
0 vote136 views1 answer
Services.AddDbContext DataSource Sqlite
SQL
0 vote128 views1 answer
Case insensitive sql
SQL
3 votes138 views1 answer
Sql case update
SQL
0 vote145 views1 answer
Postgresql create query
SQL
1 vote126 views1 answer
Select from one table where not on the other
SQL
0 vote138 views1 answer
PSQL qith variables
SQL
1 vote265 views1 answer
Import sql file from laravel
SQL
-1 vote136 views1 answer
Sql add column bit
SQL
0 vote142 views1 answer
C# get sql min date
SQL