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 vote189 views1 answer
How to fetch data from database in sql
SQL
1 vote175 views1 answer
Sql headers delphi
SQL
0 vote252 views1 answer
ORA-01400
SQL
4 votes188 views1 answer
Describe table mysql
SQL
0 vote183 views1 answer
Wordpress delete post revisions older than date "sql"
SQL
0 vote171 views1 answer
Implicit inner join table alias with id values
SQL
0 vote166 views1 answer
Oracle dynamic select into
SQL
0 vote236 views1 answer
DATEDIFF minute postgres
SQL
0 vote119 views2 answers
Denormalization in sql
SQL
0 vote163 views1 answer
Like sql for second letter of the family name
SQL