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 vote98 views1 answer
Replace \n sql
SQL
7 votes107 views2 answers
Create index mysql
SQL
1 vote52 views1 answer
File /etc/init.d/mysql not exists
SQL
0 vote128 views3 answers
Constraint sql
SQL
0 vote108 views1 answer
Vs 2019 connect to local mysql database
SQL
0 vote109 views1 answer
(PDOException(code: 2002): SQLSTATE[HY000] [2002] Permission denied at
SQL
0 vote113 views1 answer
Get the previous column of a table in mysql
SQL
5 votes104 views1 answer
Postgres integer to serial
SQL
6 votes111 views5 answers
Sql add months to date
SQL
0 vote118 views1 answer
How to find table lock and row lock in mysql
SQL