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 vote277 views1 answer
Custom row number
SQL
3 votes272 views4 answers
Order by desc postgres
SQL
0 vote263 views1 answer
Sql datediff month
SQL
3 votes284 views1 answer
Laravel database Using Named Bindings
SQL
0 vote280 views1 answer
Sql select where more than one record exists
SQL
0 vote263 views2 answers
Azure sql-datenbank
SQL
2 votes265 views1 answer
Possgress drop if exists table
SQL
13 votes282 views2 answers
Sql online compiler
SQL
0 vote270 views1 answer
Automatically update database last seen datetime in sql
SQL
0 vote271 views1 answer
Leftjoin in sql
SQL