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 vote401 views1 answer
Mariadb.service failed with result 'exit-code'
SQL
0 vote352 views1 answer
Sql get highest date from 3 tabels
SQL
0 vote364 views1 answer
Set Mamp mysql globally
SQL
0 vote314 views1 answer
Linux upload database to mysql
SQL
2 votes361 views1 answer
Oracle kill job by sid
SQL
0 vote338 views1 answer
Postgresql log
SQL
1 vote376 views4 answers
Get week day from date in sql
SQL
6 votes348 views2 answers
Find mysql version linux
SQL
1 vote358 views1 answer
Oracle create_program
SQL
3 votes361 views2 answers
SqlMessage: "Host '192.168.64.1' is not allowed to connect to this MariaDB server
SQL