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 vote247 views1 answer
ORACLE RIGHT TWO DIGITS
SQL
6 votes252 views2 answers
Foreign key sqlite3 python
SQL
3 votes226 views4 answers
Mysql decimal
SQL
0 vote186 views1 answer
Count char in java
SQL
1 vote254 views2 answers
Mysql extract number from string
SQL
0 vote258 views1 answer
Drop a view in sqlite
SQL
0 vote226 views1 answer
Oracle list subpartitions
SQL
0 vote231 views1 answer
Insert overwrite table in mysql in nifi
SQL
3 votes255 views3 answers
1396(hy00) mysql error
SQL
0 vote235 views1 answer
PDOException: SQLSTATE[HY093]: Invalid parameter numb
SQL