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

4 votes301 views1 answer
Mysql timestamp in laravel migration
SQL
1 vote289 views1 answer
Index a database column sql
SQL
0 vote296 views1 answer
Search In the Data using ObjectName
SQL
1 vote310 views2 answers
Regex starts with
SQL
1 vote336 views2 answers
Intersect sql
SQL
1 vote264 views1 answer
Insert into sql
SQL
2 votes281 views1 answer
Plsql left() function
SQL
4 votes294 views4 answers
Update select mysql
SQL
0 vote326 views1 answer
Mysql value ends with
SQL
8 votes337 views3 answers
Postgres database sizes
SQL