Re: trigger
par NGOLLE I NSILE ARIEL, SQL> set serveroutput on
SQL> set verify off
SQL> Create or replace trigger increase_form
2
3 after insert on inscription
4
5 for each row
6
7 enable
8
9 begin
10
11 update formation set nbapp =nbapp +1
12
13 where codform= :new.codform;
14
15 dbms_output.put_line('Une inscription vient d etre ajouté');
16
17 end;
18
19 /
DÚclencheur crÚÚ.
SQL> insert into inscription values(10,2,2000);
Une inscription vient d etre ajouté
1 ligne crÚÚe.
SQL>