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 vote377 views2 answers
Unique key
SQL
4 votes336 views2 answers
Oracle last day of month
SQL
0 vote396 views1 answer
Download sql file of countries names
SQL
0 vote345 views1 answer
Connexion mysql
SQL
0 vote319 views1 answer
Delete double on SQL with multiple primary keys
SQL
2 votes364 views3 answers
Row number mysql
SQL
1 vote345 views1 answer
Select from describe sql
SQL
1 vote362 views2 answers
Sql server find all foreign keys that reference a column
SQL
0 vote352 views1 answer
Oracle 11g forget password
SQL
0 vote336 views1 answer
UNION ALL LEFT JOIN
SQL