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

5 votes199 views1 answer
Sql use database
SQL
0 vote216 views1 answer
Postgres multiple left join causing duplicates jsonb_agg
SQL
8 votes161 views2 answers
Alter column name in mssql
SQL
0 vote214 views2 answers
Mysql decimal remove trailing zeros
SQL
0 vote171 views1 answer
Requete sql mise a jour content dans un colone mysql
SQL
7 votes232 views2 answers
How to create index mysql
SQL
1 vote226 views3 answers
Psql: error: FATAL: role "postgres" does not exist
SQL
52 votes336 views6 answers
Rename column sql
SQL
1 vote200 views1 answer
How much every mysql database record takes from diskspace
SQL
0 vote215 views1 answer
Get primary key of table
SQL