1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
| CREATE OR REPLACE TRIGGER DML_DOD
instead of insert
on dod_view
for each row
begin
insert into dod
select seq_dod_id.nextval, :new.date_besoin, :new.date_recueil, :new.date_fourniture,
:new.nom_operation, :new.nom_zone, :new.origine_besoin, :new.geom
dod_etat.id, dod_priorite.id, etat_crise.id, implication_nationale.id, interet_national.id,
sensibilite.id, systeme_arme.id, type_implication.id, type_intervention.id, utilisateur.id
from dod_etat, dod_priorite, etat_crise, implication_nationale, interet_national, sensibilite,
systeme_arme, type_implication, type_intervention, utilisateur
where dod_etat.libelle = :new.dod_etat_libelle AND
etat_crise.libelle = :new.etat_crise_libelle AND
implication_nationale.libelle = :new.implication_nationale_libelle AND
interet_national.libelle = :new.interet_national_libelle AND
sensibilite.libelle = :new.sensibilite_libelle AND
systeme_arme.libelle = :new.systeme_arme_libelle AND
type_implication.libelle = :new.type_implication_libelle AND
type_intervention.libelle = :new.type_intervention_libelle AND
dod_priorite.libelle = :new.dod_priorite_libelle AND
utilisateur.login = :new.utilisateur_login;
end ; |
Partager