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 vote286 views1 answer
To Create directory
SQL
0 vote273 views1 answer
Sql delete dastabase
SQL
1 vote292 views1 answer
Mysql select for update ejemplo
SQL
0 vote245 views1 answer
Grant owner postgresql
SQL
0 vote268 views1 answer
Postgressql uuid
SQL
0 vote272 views1 answer
Snap craft
SQL
0 vote262 views1 answer
Oracle query to see what scema i am working in
SQL
1 vote277 views1 answer
Oracle sql average
SQL
0 vote349 views1 answer
HOW to select specific table data from an mysql databse server:
SQL
3 votes298 views2 answers
Order by postgresql
SQL