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 vote173 views2 answers
Difference between in and between in sql
SQL
0 vote203 views1 answer
Get date from timestamp in mysql
SQL
0 vote197 views1 answer
Flush user resource mysql
SQL
0 vote198 views1 answer
Selecting duplicates
SQL
4 votes200 views2 answers
Installing sql on ubuntu
SQL
0 vote176 views1 answer
Automate mysql cli query
SQL
0 vote233 views1 answer
Best practive to pass multiple table to stored procedure in sql server
SQL
1 vote193 views1 answer
Create sqlite database in laravel
SQL
3 votes183 views3 answers
How to set up an auto incrementing id db browser
SQL
1 vote198 views1 answer
Oracle compile schema
SQL