Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE OR REPLACE TRIGGER ДОКУМЕНТS_A_IUD_S AFTER DELETE OR INSERT OR UPDATE OF КОЛИЧЕСТВО_ДОКУМЕНТОВ, ЗАЯ_ЗАЯ_ID ON ДОКУМЕНТS
- DECLARE
- CURSOR ДОК IS SELECT DISTINCT ДОК_ID FROM ДОКУМЕНТS;КОЛИЧЕСТВО NUMBER(4);
- BEGIN
- FOR CUR_БОЛ IN ДОК LOOP
- SELECT SUM(ЧИСЛО_КОЕК) INTO КОЛИЧЕСТВО FROM ДОКУМЕНТS WHERE ДОКУМЕНТS.ЗАЯ_ЗАЯ_ID = CUR_БОЛ.ЗАЯ_ID;
- UPDATE ЗАЯВЛЕНИЕS SET КОЛИЧЕСТВО_ДОКУМЕНТОВ = КОЛИЧЕСТВО WHERE ЗАЯВЛЕНИЕS.ЗАЯ_ID = CUR_БОЛ.ЗАЯ_ID;
- END LOOP;
- DELETE ДОКУМЕНТS;
- END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement