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

2 votes336 views2 answers
Mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password]
SQL
0 vote314 views1 answer
Sql column as header
SQL
0 vote344 views1 answer
Contraint default SQL
SQL
4 votes315 views1 answer
Oracle session date format
SQL
0 vote308 views1 answer
Connect postgresql using a connection string
SQL
0 vote311 views1 answer
Sqlalchemy query join many to many
SQL
8 votes324 views1 answer
Sql limit results returned
SQL
2 votes301 views2 answers
Laravel query builder toSql
SQL
-1 vote305 views2 answers
On update cascade
SQL
0 vote318 views1 answer
Permission denied postgres \copy csv command line
SQL