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

1 vote381 views2 answers
Postgres select from last 3 months
SQL
4 votes398 views1 answer
Sql delete multiple conditions
SQL
3 votes376 views2 answers
To_char sql
SQL
0 vote362 views1 answer
Get foreign table names mysql
SQL
0 vote365 views3 answers
Postgresql grant alter table to user
SQL
0 vote335 views1 answer
Create table employees oracle
SQL
3 votes310 views2 answers
Mysql sum with condition
SQL
0 vote328 views1 answer
Mysql select distinct date from timestamp
SQL
0 vote383 views1 answer
How to take sum of column with same id in "JPQL?"
SQL
0 vote331 views1 answer
Duplicate foreign key constraint name
SQL