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

34 votes147 views6 answers
Alter table add foreign key mysql
SQL
0 vote109 views1 answer
Print boolean in plsql
SQL
1 vote117 views1 answer
Myql find duplicates
SQL
1 vote106 views1 answer
Oracle create program if no exists
SQL
6 votes141 views2 answers
Install psql mac
SQL
0 vote64 views1 answer
Mssql view column data type
SQL
0 vote125 views1 answer
Default column value in sql same as another column laravel
SQL
-1 vote114 views1 answer
SQL SERVER microsoft How to Add Column at Specific Location in Table
SQL
1 vote115 views1 answer
How to set up a trigger in sql
SQL
0 vote125 views1 answer
Define a variable in mysql from select
SQL