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 vote274 views2 answers
Add new column after in sql
SQL
1 vote275 views1 answer
Oracle insert multiple rows into same table
SQL
2 votes267 views2 answers
Postgresql search all tables for column name
SQL
19 votes278 views6 answers
Create table sqlite
SQL
4 votes283 views2 answers
Truncate oracle
SQL
33 votes266 views2 answers
Postgres how to add field created at
SQL
0 vote273 views1 answer
Sql update subtract value
SQL
0 vote252 views1 answer
Postgres select except
SQL
1 vote285 views1 answer
Insert value to new table by joining 2 different tables
SQL
7 votes271 views2 answers
What is sql clause
SQL