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 vote320 views1 answer
Which lock mode is not available in sql
SQL
4 votes329 views2 answers
Postgre sql create table
SQL
1 vote352 views1 answer
Sql how to replace full stop
SQL
2 votes332 views1 answer
Mysql now format
SQL
9 votes306 views2 answers
Default number in sql
SQL
0 vote316 views1 answer
Sql server order by nulls last
SQL
6 votes315 views2 answers
Mysql first day of month
SQL
0 vote328 views1 answer
How get data from database if id not found then search another column
SQL
0 vote365 views1 answer
How to use sqlcommand
SQL
1 vote312 views2 answers
Sql convert datetime to year month
SQL