Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- create or replace trigger tr_note
- before update or insert
- ON MATIERESUIVISAISIENOTE
- for each row
- Declare
- v_anne integer;
- begin
- v_anne := extract(year from : New.sysdate);
- if(updating) then
- update MATIERESUIVISAISIENOTE
- set note=:new.note and nbrfois=nbrfois+1
- where codemat=:new codemat and cin=:new cin and anne=:v_anne ;
- if(inserting)update
- MATIERESUIVISAISIENOTE
- set nbrfois=1;
- end if;
- end;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement