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

5 votes226 views3 answers
Select tables from mysql database
SQL
0 vote194 views2 answers
Temp Space
SQL
0 vote193 views1 answer
Kill thread
SQL
1 vote188 views3 answers
String to int mysql
SQL
1 vote188 views2 answers
ImportError: No module named mysql.connector
SQL
0 vote224 views1 answer
Insert output identity
SQL
0 vote144 views1 answer
Bigquery information_schema schema all columns
SQL
0 vote200 views1 answer
Is not sql
SQL
0 vote337 views1 answer
How to find the most occuring in SQL
SQL
1 vote262 views1 answer
Sql to mongodb query converter
SQL