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 vote359 views1 answer
Select even number id data from table
SQL
-1 vote358 views2 answers
How to select the lowest values from table per client sql
SQL
0 vote321 views1 answer
How to see the content of tables in pgadmin
SQL
0 vote347 views1 answer
Mysql command line ubuntu
SQL
0 vote354 views1 answer
Mysql workbench indent formatting
SQL
5 votes367 views4 answers
Rollback to in sql
SQL
0 vote397 views1 answer
Mysql edit trigger
SQL
0 vote375 views1 answer
My sql data file extention
SQL
1 vote358 views1 answer
Oracle convert run duration to number
SQL
0 vote346 views1 answer
Sql cross apply vs join
SQL