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 vote378 views1 answer
C# mysql data reader from two tables
SQL
1 vote338 views3 answers
Postgresql connect to database
SQL
0 vote337 views1 answer
Postgresql create user roles
SQL
0 vote351 views4 answers
Best data type to represent money in mysql
SQL
1 vote352 views1 answer
Create index concurrently postgres
SQL
0 vote378 views1 answer
Change role postgres
SQL
3 votes359 views3 answers
C# sql select
SQL
1 vote347 views2 answers
Mysql error 1215
SQL
8 votes348 views1 answer
Oracle all_source package body
SQL
0 vote378 views1 answer
TSQL Code Snippet For Optimized Sales Query
SQL