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 vote229 views1 answer
Sql output select
SQL
0 vote219 views1 answer
MySQL import data from large CSV file
SQL
1 vote238 views2 answers
Oracle leftmost characters
SQL
1 vote291 views1 answer
Sql and
SQL
0 vote222 views1 answer
Sql alter column name sql server
SQL
1 vote222 views1 answer
Mysql month name extract
SQL
1 vote227 views1 answer
Second last highest id in sql
SQL
2 votes207 views2 answers
Mysql get time from datetime
SQL
1 vote199 views1 answer
Mysqli connect
SQL
0 vote223 views1 answer
Drop all triggers oracle
SQL