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

4 votes198 views2 answers
Mysql select where starts with
SQL
0 vote217 views1 answer
Sub query in linq
SQL
1 vote185 views1 answer
Login to database mysql terminal
SQL
0 vote163 views1 answer
Now() -1 mysql
SQL
1 vote217 views1 answer
Oracle avg
SQL
0 vote225 views1 answer
How to close external sql connection in laravel
SQL
0 vote201 views1 answer
Inspecting a column unique/distinct values in SQL
SQL
10 votes205 views2 answers
Sql rtrim
SQL
0 vote208 views1 answer
Join in update query in mysql
SQL
3 votes214 views1 answer
Increment integer in table sql
SQL